View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Ramage Dave Ramage is offline
external usenet poster
 
Posts: 44
Default Auto_open OR Workbook_open

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

"Baapi" wrote:

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,
--
Baapi