autorun macro at Excel open

[Duane]

Searched, found nothing.

How do I run a macro on Excel open? I have a macro that
calls my form, but I can't find how to autorun the macro.

Thanks much

 

[Bob Phillips]

Duane,

Two ways.

Call the macro Auto_Open and put it in a general module.

Use the Workbook_Open event macro in ThisWorkbook, and put your code in
there.

--

HTH

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

 

[Tom Ogilvy]

Just some added info:
Here is a source of information on Events - although written for xl97, it is
pertinent to later versions as well.

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

 

[Otto Moehrbach]

Duane
You say "How do I run a macro on Excel open?" But then you talk about
opening a form upon opening. That implies that you mean when the file
opens, not when Excel opens. What Bob gave you works on file open, not on
Excel open. HTH Otto