Run Macro Upon Open Workbook?

[CWit]

Hello, I have a macro that I want to run when a workbook is opene
automatically. I only want it to run once. How would I do this? thank

 

[Bob Phillips]

Name the macro Auto_Open, or put the code in the Workbook_Open event code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
two ways:
1. In your workbook module (not in a standard module) use the
Workbook_Open() event procedure

2. Rename your macro to Auto_Open()

 

[CWit]

Thanks works great