Auto Start Macro in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ABC Seamless Wayne - 23 Jan 2008 02:16 GMT

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!

Reply to this Message

Otto Moehrbach - 23 Jan 2008 02:40 GMT

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

>I would like to know how to create a Macro in Excel (Maybe something
>better),
[quoted text clipped - 10 lines]
>
> Thanks in advance!

Reply to this Message

ABC Seamless Wayne - 24 Jan 2008 20:26 GMT

Thank you very much. Auto_Open works just fine.

> You can use the macro you wrote except name it:
> Sub Auto_Open
[quoted text clipped - 15 lines]
> >
> > Thanks in advance!

Reply to this Message