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

  • Thread starter Thread starter carljonesuk
  • Start date Start date
C

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
 
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)
 
Back
Top