Opening file to a certain worksheet

  • Thread starter Thread starter carljonesuk
  • Start date Start date
C

carljonesuk

I need excel to open to a certain worksheet so that i can run a macro t
adjust every other sheet to users screen resolution.

How do i do this?

Any help would be useful!

Thanks
 
Hi
not quite sure what you want but if you want to activate a specific
sheet for one workbook put the following code in the workbookmodule of
this excel file:
Private Sub Workbook_Open()
Worksheets("Sheet3").Activate '-> activates sheet3 on startup
End Sub

Frank
 
Back
Top