Autorun a macro

jamesgw · May 13th, 2002, 08:16 AM

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

THANKS!!

eddd82 · May 13th, 2002, 08:19 AM

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 · May 13th, 2002, 08:20 AM

Quote:

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.



Private Sub Workbook_Open()

   Call YourMacroNameGoesHere

End Sub

_________________
Kind Regards,
Ivan F Moala
Have a Nice day

[ This Message was edited by: Ivan F Moala on 2002-05-13 07:22 ]

jamesgw · May 13th, 2002, 02:18 PM

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 · May 14th, 2002, 11:00 AM

May 13th, 2002, 08:19 AM	#2
eddd82 Board Regular Join Date: Apr 2002 Location: Ireland Posts: 107	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 __________________ [Brian]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 08:16 AM	#1
jamesgw New Member Join Date: May 2002 Posts: 10	Can anyone tell me if it's possible to run a user-created macro automatically when a workbook is opened? THANKS!!

May 13th, 2002, 02:18 PM	#4
jamesgw New Member Join Date: May 2002 Posts: 10	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"?

May 14th, 2002, 11:00 AM	#5
jamesgw New Member Join Date: May 2002 Posts: 10