On open workbook go to a specific worksheet

[Guest]

On opening a workbook I would like it go to a specific worksheet e.g. index
page. Is there a macro that will perform this function please? Thank you for
your assistance.

Andy Josolyne

 

[Harald Staff]

Sub Auto_open()
Sheets("Index").Activate
Cells(1, 1).Select
End Sub

HTH. Best wishes Harald

 

[Guest]

Harald

Many thanks for your fast response. Where do I store the macro - in a new
one, or in the code stores in the Excel icon?

 

[Harald Staff]

Hi

In the workbook itself. Open it, then open the VB editor (Alt F11 or
similar). Insert > Module, paste it in, save.

HTH. best wishes Harald

 

[Bob Phillips]

Store it in a standard code module.

Go into the VBE (Alt-F11), and from the men, Insert>Module.

--

HTH

RP
(remove nothere from the email address if mailing direct)