Autoexec Macro

  • Thread starter Thread starter ek2k3
  • Start date Start date
E

ek2k3

Hi I'm needing a macro that when the spread sheet is opened i
automatuically goes to the menu sheet, regardless as to where the use
last saved it, I know how to do it in access and it doesn't work th
same in excel, I was told about calling it autostart and that didn'
work either! Please help as this is rather urgent!


Regards

Shannon Dun
 
Call the macro Auto_Open and put it in a standard module.
 
Change Background to the name of the menu sheet


Sub Auto_Open()
Worksheets("Background").Activate
Exit sub
 
You must log in or register to reply here.

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 for all Excel Workbooks to print to PDF 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Macro help 2
How to chart data generated in a macro in any desired sheet. Pleas 1
Run two macros for two different sheets 11
Working of formula in Macro. 1
Disable Change-event macro 6

Back
Top