how do i run an autoexecute macro in excel

[Guest]

how do i set a macro to autoexecute when an excel worksheet is opened - i can
find no data in help for autoexecute

 

[davesexcel]

you need to put your macro in a worksheet module or a workbook module

for the workbook module right click on the xl symbol at the top left of
the sreen and select view code and drop the box to select workbook, then
in the right box select the event you want for the macro to start, such
as workbook open will start your macro when you open your workbook,
there is lots of info on workbook and worksheet events

 

[Gord Dibben]

Either use a Workbook_Open sub in Thisworkbook module

or

Auto_Open sub in a general module.


Gord Dibben MS Excel MVP

On Thu, 6 Jul 2006 06:26:02 -0700, robin morris <robin