View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raj[_2_] Raj[_2_] is offline
external usenet poster
 
Posts: 150
Default Worksheet activation on Opening Workbook

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