Window not active on Auto_Open

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

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
 
Hi Steven,

Post the code that is supposed to activate the required worksheet in the
Auto_Open.
 
You probably just need to add an activate statement at the end of the macro
like

Sheets("sheet1").activate
 
Back
Top