Which Fires First?

O

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
 
R

RichardSchollar

Hi

The Workbook_Open event that fires first - ie before Auto_Open.

Best regards

Richard
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto_Open over Private Sub Workbook_Open() 2
Call subroutine problem 1
sheet event wait for another event? 6
active combobox - possible to configure as display value andcoordinate value? 3
Using IRibbonUI in VBA Excel 2010 7
model in excel: auto_open and in thisworkbook workbook_open 0
Macro to delete macro? 4
Firing Event in another user form 1

Top