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

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

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