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
|