Window not active on Auto_Open

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
 
O

OssieMac

Hi Steven,

Post the code that is supposed to activate the required worksheet in the
Auto_Open.
 
J

Joel

You probably just need to add an activate statement at the end of the macro
like

Sheets("sheet1").activate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open my default template when right click, select New MS Word doc within a folder 0
Shortcuts in OneDrive 0
Set as Default Template not working 0
Active Content in this file is blocked issue 1
Adding custom menus to existing excel application 0
Macro to open file bypasses Auto_Open 4
Hyperlink fails to open on the first click 0
Publisher 2019 Format Picture window size too large to display OK button 0

Top