ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Open on specific worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/52545-open-specific-worksheet.html)

Adrian

Open on specific worksheet
 
How can I make an excell file alwasy open at a specific worksheet, no mater
which sheet was active when saved

Ian

Open on specific worksheet
 
Private Sub Workbook_Open()
Worksheets("Sheet2").Activate
End Sub


--
Ian
--
"Adrian" wrote in message
...
How can I make an excell file alwasy open at a specific worksheet, no
mater
which sheet was active when saved





All times are GMT +1. The time now is 12:47 PM.

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