Which Fires First?

[okrob]

Which code would fire first, the workbook_Open event in the
ThisWorkbook module, or Auto_Open in a general code module?
Either way, I need to make sure the ThisWorkbook code fires first.
Rob

 

[RichardSchollar]

Hi

The Workbook_Open event that fires first - ie before Auto_Open.

Best regards

Richard

 

[okrob]

Hi

The Workbook_Open event that fires first - ie before Auto_Open.

Best regards

Richard



- Show quoted text -

Thanks...

 

[Bob Phillips]

Why would you not just add a Msgbox in each procedure, and see for yourself?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ron de Bruin]

Check out
http://www.cpearson.com/excel/events.htm