Even if the auto_open is the old way I think it may have the edge.

If you have run someone else's bad code on your machine then they may
have left your application as application.enableevents = false, if
this is the case then when you try to run the workbooks_open event it
won't fire.

The EnableEvents property doesn't seem to affect an Auto_open routine.

J

"Bob Phillips" wrote in message ...
Stu,

Either name the macro Auto_Open and put it in a normal code module (old way)
or put it in Worksheet_Open event code in ThisWorkbook code module (new
way).

--

HTH

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

"Stu" wrote in message
...
How do i get a macro to run when an excel file is opened without having
to click run macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/