View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ABC Seamless Wayne[_2_] ABC Seamless Wayne[_2_] is offline
external usenet poster
 
Posts: 5
Default Auto Start Macro in Excel

I would like to know how to create a Macro in Excel (Maybe something better),
that would automatically go to "Sheet1" Cell A5 at the launch of Excel.
Currently I have

Sub Auto_Activate()
Sheets("Sheet1").Select
Range("A5").Select
End Sub

which is not working. When I leave, saving the file and launch again it
brings me back to the Sheet I was on at last save.

Thanks in advance!