| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening on a specific worksheet | Excel Discussion (Misc queries) | |||
| Opening specific worksheet from hyperlink more questions | Excel Discussion (Misc queries) | |||
| Opening Excel file on a specific worksheet | Excel Worksheet Functions | |||
| opening a worksheet at a specific point | New Users to Excel | |||
| Opening specific worksheet from hyperlink | Excel Discussion (Misc queries) | |||
Linear Mode
