Autoexec Macro

[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

 

[Vasant Nanavati]

Call the macro Autpen and put it in a standard module.

 

[David Adamson]

Change Background to the name of the menu sheet


Sub Autpen()
Worksheets("Background").Activate
Exit sub

 

[ek2k3]

Thank You Very Much!

It works and is perfect


Thank You Agai