Open workbook at specific sheet

  • Thread starter Thread starter Adele Russell
  • Start date Start date
A

Adele Russell

How do I open a particular workbook and get it to go to a
specific sheet ie Sheet 2
 
Hi
put the following code in your workbook_module
Private Sub Workbook_Open()
Worksheets("Sheet2").Activate
End Sub

HTH
Frank
 
Hi Frank
Appreciate your assistance
Thanks
-----Original Message-----
Hi
put the following code in your workbook_module
Private Sub Workbook_Open()
Worksheets("Sheet2").Activate
End Sub

HTH
Frank




.
 
Back
Top