Excel VBA - Opening a workbook to a specific sheet every time
 

I'm doing a spread sheet for my A-Level project and need a macro to ope
to the main menu every time the file is opened so that another macr
can be run easily from that sheet to adjust the other sheets to th
User's screen Resolution.

How do I do this?

Any comments would be useful

Thanks

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

Excel VBA - Opening a workbook to a specific sheet every time
 

Not sure what you mean by open to the main menu, but there are 2 ways to
automatically run a macro when a workbook opens. The first is to use the
Workbook_Open event and add your code there, the second is to name your
macro Auto_Open.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"carljonesuk " wrote in message
...
I'm doing a spread sheet for my A-Level project and need a macro to open
to the main menu every time the file is opened so that another macro
can be run easily from that sheet to adjust the other sheets to the
User's screen Resolution.

How do I do this?

Any comments would be useful

Thanks!


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