Auto run Macro 2002

[Guest]

Hi

I need a spreadsheet to opne on the same sheet whenever it is opened. I use
to be able create a macro and name it Auto_run and it would automatically run
when the spreadsheet is opened but this Auto_run does not work in 2002
version of excel.

Have they cahnged the naming or is there amother simpler way to get it to do
what I want.

All help is much appreciated.

Cheers

PJ

 

[Guest]

Hi,

Use the inbuilt workbook_open event to select the sheet you want.
Alt+F11 to open editor. Doubleclick thisworkbook and paste this in:-

Private Sub Workbook_Open()
Sheets("MySheet").Select
End Sub

Mike

 

[Zone]

By the way, the sub you're thinking of is Auto_open, not Auto_run