autorun macro at Excel open

  • Thread starter Thread starter Duane
  • Start date Start date
D

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
 
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)
 
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
 
Back
Top