startup macro

Posted by Jimbo on July 31, 2001 10:40 AM

Is there anyway to have a excel file automatically go to a particular worksheet when it is opened?

Posted by Sarah on July 31, 2001 10:55 AM

Hi Jimbo,
In a VBA Module enter:

Sub Auto_Open()
Sheets("Sheet1").Select
End Sub

Where Sheet1 is the name of the sheet you want to select on opening.
Hope this helps,
Sarah

Posted by Jimbo on July 31, 2001 2:58 PM

worked like a charm, thanks!