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!

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!

Thank you very much. Auto_Open works just fine.


"Otto Moehrbach" wrote:

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!