ramasterre
Active Member
- Joined
- Oct 5, 2004
- Messages
- 253
how do i tell excel to always open a document with a particular sheet activated? is this just a setting or do i need a line of code?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
quick and easy question
- Thread starter ramasterre
- Start date
just_jon
Legend
- Joined
- Sep 3, 2002
- Messages
- 10,473
One way -
<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_Open()
Sheets("Sheet2").Activate
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>
Goes in the ThisWorkbook module; must answer in the affirmative to the macros prompt when opening the workbook.
<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_Open()
Sheets("Sheet2").Activate
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>
Goes in the ThisWorkbook module; must answer in the affirmative to the macros prompt when opening the workbook.
Upvote
0
ray:Similar threads
- Question
