Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a workbook with two sheets: Sheet1 and Sheet2. Sheet1 has code for freezing the window panes on cell L2. On opening the workbook, I want Sheet1 to be activated and the panes frozen. To achieve this I have included code for Worksheets("Sheet1").activate in ThisWorkbooks open event. When the workbook is opened, the Sheet1 is active sheet. However, the freeze panes does not work. However, when I click Sheet2, followed by Sheet1, the freeze panes is activated in Sheet1. How can I ensure that Sheet1 is activated on opening of the workbook. Thanks in advance for all the help. Regards, Raj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent worksheet from opening in a workbook | Excel Worksheet Functions | |||
Worksheet Activation from another workbook | Excel Programming | |||
Workbook activation code | Excel Programming | |||
Workbook activation issue | Excel Programming | |||
Detecting workbook activation | Excel Programming |