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
|