Workbook.Open Event Procedure not firing
 

Can anyone shed light why one of event procedures is not running.

I have a couple of workbooks whose formulae can link in either direction
depending on a control value held in a third "control" file. In order that
the status of that third file is always recognised I created a Workbook.Open
Event Procedure that Opens the control file if it is not already open. That
runs fine.(The procedure is held in Thisworkbook)

Recently I was fed up with getting too many divide by zero errors so I
included a small user-defined function in a code module to handle this. Now
my Workbook.Open Event procedure won't fire. If I remove the user-defined
function it fires. Confused? I was!

Anyone any ideas as to what is happening?

Workbook.Open Event Procedure not firing
 

Hi Gordon

If you have Application.EnableEvents = False
in your code the Workbook open event will not run

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Gordon Rodman" wrote in message ...
Can anyone shed light why one of event procedures is not running.

I have a couple of workbooks whose formulae can link in either direction
depending on a control value held in a third "control" file. In order that
the status of that third file is always recognised I created a Workbook.Open
Event Procedure that Opens the control file if it is not already open. That
runs fine.(The procedure is held in Thisworkbook)

Recently I was fed up with getting too many divide by zero errors so I
included a small user-defined function in a code module to handle this. Now
my Workbook.Open Event procedure won't fire. If I remove the user-defined
function it fires. Confused? I was!

Anyone any ideas as to what is happening?