View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Childs Tim Childs is offline
external usenet poster
 
Posts: 128
Default Application Event - Opening Workbook

Hi

thanks for that response

as faras I can tell tis is not happening as the procedure is stuck on the
first line as the Excel application is being opened

bw

Tim

"gocush" /delete wrote in message
...
Yes, I was just wondering if you triggered the event at the workbook level

it
might make some difference.
Okay the event you are using is in a Utility xls and is triggered when it
opens as well as when it opens other xls files. Is it possible, for

instance
that of you workbooks might have some code like:
Application.EnableEvents=False
Some other code which crashed
Application.EnableEvents=True

Since Application.EnableEvents does not reset itself, this would
prevent you app_event from firing.
Just a guess....