Displaying a specific worksheet on opening application

  • Thread starter Thread starter John
  • Start date Start date
J

John

In my AutoClose, all sheets are hidden save the charts and
one other (labelled Warning). If macros are not enabled,
the first chart is always displayed. Is there a way to
ensure that the Warning sheet, which is to the left of the
first chart, is always displayed?
Thanks for your help.
 
John,

Create an Auto_Open macro with

Worksheets("Warning").Activate

--

HTH

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