Go to a specific sheet on open
 

I would like the workbook to go to a specifc worksheet on opening e.g. Index.
I there a macro I can use? Many thanks for your assistance.

Regards

Andy

Go to a specific sheet on open
 

Andy,

Copy the following code into the ThisWorkbook object in VBE.

Private Sub Workbook_Open()

ThisWorkbook.Sheets("Index").Activate

End Sub

http://HelpExcel.com

"Andy Josolyne" wrote:

I would like the workbook to go to a specifc worksheet on opening e.g. Index.
I there a macro I can use? Many thanks for your assistance.

Regards

Andy