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" <(E-Mail Removed)> wrote in
message news:548240D8-E57B-4A32-B933-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in
> message news:548240D8-E57B-4A32-B933-(E-Mail Removed)...
> >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!
>
>
>