ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Displaying a specific worksheet on opening application (https://www.excelbanter.com/excel-programming/291857-displaying-specific-worksheet-opening-application.html)

john

Displaying a specific worksheet on opening application
 
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.

Bob Phillips[_6_]

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.





All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com