Hi Debashis,
Do as Below :
1. Open the Visual Editor (Alt+F11)
2. Double Click "This Workbook"
3. Paste the below code
Private Sub Workbook_Open()
Sheets("Sheet3").Activate
End Sub
After this, whenever you opened your workbook, sheet3 will be activated.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
----------------------------------------------------------------------------
---------------------------------
There are 10 kinds of people: Those who understand binary and those who
don't.
----------------------------------------------------------------------------
---------------------------------
From: [email protected] [mailto:[email protected]]
On Behalf Of DEBASHIS BANERJEE
Sent: Tuesday, June 30, 2009 11:47 AM
To: [email protected]
Subject: $$Excel-Macros$$ Macro for Opening a Particular Sheet .
I am enclosing herewith an Excel File containing Three Sheet numbering 1 ,2
and 3.
I like to write a Macro so that only sheet No 3 will be opened as and when
this file is opened .
Generally , it is seen that active sheet at the time of closing the file
is opened when it is opened next time.
But I like to mandate the page no 3 to be opened every time..
kindly suggest .
Thanks and regards
Debashis.
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
If you find any spam message in the group, please send an email to:
Ayush Jain @ [email protected] or
Ashish Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
