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

[carljonesuk]

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

 

[Bob Phillips]

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 Autpen.

--

HTH

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