| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window not active on Auto_Open
I have an excel file that opens with a shortcut on my desktop toolbar that
opens the file. It has an Auto_Open macro in it. When the file opens it opens ok but the window is not active. (ie I have to click on the sheet to activate it.) Why is this? Thank you, Steven |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window not active on Auto_Open
Hi Steven,
Post the code that is supposed to activate the required worksheet in the Auto_Open. -- Regards, OssieMac "Steven" wrote: I have an excel file that opens with a shortcut on my desktop toolbar that opens the file. It has an Auto_Open macro in it. When the file opens it opens ok but the window is not active. (ie I have to click on the sheet to activate it.) Why is this? Thank you, Steven |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window not active on Auto_Open
You probably just need to add an activate statement at the end of the macro
like Sheets("sheet1").activate "OssieMac" wrote: Hi Steven, Post the code that is supposed to activate the required worksheet in the Auto_Open. -- Regards, OssieMac "Steven" wrote: I have an excel file that opens with a shortcut on my desktop toolbar that opens the file. It has an Auto_Open macro in it. When the file opens it opens ok but the window is not active. (ie I have to click on the sheet to activate it.) Why is this? Thank you, Steven |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Go to Last Active Window | Excel Programming | |||
| how to set workbook window active | Excel Programming | |||
| How to Active Window | Excel Programming | |||
| Active Window Question | Excel Discussion (Misc queries) | |||
| active window | Excel Programming | |||
Linear Mode
