Auto Start Macro in Excel
You can use the macro you wrote except name it:
Sub Auto_Open
That macro will not fire if the file is opened by code. In that case use a
Workbook_Open event macro. Note that a Workbook_Open event macro must be
placed in the workbook module. Post back if you need more. HTH Otto
"ABC Seamless Wayne" wrote in
message ...
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!
|