Auto_open OR Workbook_open

[Guest]

Hi,

I have a couple of quaestions...

1. Which of these two events occurs first when an excel workbook is opened?
2. Does this also depend on whether the Excel application (not the
particular workbook) is already open?

I'm asking these questions in regard to scheduling the macro for a later
time...

Any help would be greatly appreciated

Thanks,

 

[Bob Phillips]

workbook_open first

makes no difference whether Excel started or not, it only makes a difference
if opening the workbook from code, then auto_open doesn't fire.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

A quick test with a MsgBox function in each procedure shows that the
Workbook_Open fires first, regardless of whether the Excel application is
already running.

Note that before either runs you will likely get the 'Ok to run macros'
dialog.

Cheers,
Dave