Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
open to a certain sheet tab in a different workbook | New Users to Excel | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Open workbook on same sheet? | Excel Discussion (Misc queries) | |||
Open workbook at a particular sheet | New Users to Excel | |||
open sheet on workbook open | Excel Programming |