Which Fires First?
 

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

Which Fires First?
 

Hi

The Workbook_Open event that fires first - ie before Auto_Open.

Best regards

Richard


On 22 Feb, 14:19, "okrob" wrote:
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

Which Fires First?
 

On Feb 22, 8:22 am, "RichardSchollar"
wrote:
Hi

The Workbook_Open event that fires first - ie before Auto_Open.

Best regards

Richard

On 22 Feb, 14:19, "okrob" wrote:



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- Hide quoted text -

- Show quoted text -

Thanks...

Which Fires First?
 

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)



"okrob" wrote in message
oups.com...
On Feb 22, 8:22 am, "RichardSchollar"
wrote:
Hi

The Workbook_Open event that fires first - ie before Auto_Open.

Best regards

Richard

On 22 Feb, 14:19, "okrob" wrote:



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- Hide quoted text -

- Show quoted text -

Thanks...

Which Fires First?
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"okrob" wrote in message oups.com...
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