View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Displaying a specific worksheet on opening application

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)

"John" wrote in message
...
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.