Autorun a macro

[jamesgw]

Can anyone tell me if it's possible to run a user-created macro automatically when a workbook is opened?

THANKS!!

 

[eddd82]

Yeah think so. when u open VBA click on thisworkbook and then choose the open property and set the macro to run within the function

 

[Ivan F Moala]

On 2002-05-13 07:16, jamesgw wrote:
Can anyone tell me if it's possible to run a user-created macro automatically when a workbook is opened?

THANKS!!

Placed in the Thisworkbook object
Alt + F11
Ctrl + R
Double click on Thisworkbook
Paste this code in.<pre/>
Private Sub Workbook_Open()
Call YourMacroNameGoesHere
End Sub</pre>


_________________
Kind Regards,<font size=+2><font color="red"> I<font color="blue">van<font color="red"> F M</font color="blue">oala</font><MARQUEE>Have a Nice day

</MARQUEE>
This message was edited by Ivan F Moala on 2002-05-13 07:22

 

[jamesgw]

Thanks eddd82 and Ivan. That seemed to work!!

NOW, ...

CAN YOU TELL ME what command can I put in the open workbook macro that will accept "ENABLE MACROS"?

 

[jamesgw]

[No message]