View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan Nordgreen[_2_] Jan Nordgreen[_2_] is offline
external usenet poster
 
Posts: 5
Default Open workbook with designated sheet

I Use winxp and excel2000.

I would like my workbook to always open with the sheet called "panel de
control", so I have tried:

Private Sub Workbook_Open()
Sheets("panel de control").Select
End Sub

It opens with the sheet I was in when I saved the file last time, and then
switches to the sheet "panel de control".

To avoid seeing the sheet I was in when I saved last, I have tried:

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Sheets("panel de control").Select
Application.ScreenUpdating = True
End Sub

That did not improve things.

Any suggestions?

Sincerely,

Jan Nordgreen