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

Macro to open file bypasses Auto_Open 4
Auto_open inputbox before showing the sheets 1
Change file to read only 3
Auto_Open Code on Worksheet 2
Expand/collapse toolbar ribbon 6
Triggering auto_open 5
trying to replace auto_open with something like workbook_open 1
Opening a file from another file 1

Top