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

--
Message posted from http://www.ExcelForum.com

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

--

Vasant

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


Regards

Shannon Dunn


---
Message posted from http://www.ExcelForum.com/

Change Background to the name of the menu sheet


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


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


Regards

Shannon Dunn


---
Message posted from http://www.ExcelForum.com/

Thank You Very Much!

It works and is perfect


Thank You Agai

--
Message posted from http://www.ExcelForum.com