Excel 2003 - VBA - Workbook Open Event

  • Thread starter Thread starter Craig Brandt
  • Start date Start date
C

Craig Brandt

Hi Guys:



A quick question on the "Workbook Open" event: When I load up Excel and open
the workbook, this event triggers. If I then close the workbook, without
closing Excel, then open the workbook, it does not occur. Close down the
worksheet and Excel, then open it, it triggers.

Is this normal operation?

Could it have to do with the possibility the I had set
Application.EnableEvents = False, before exiting the workbook.



Craig
 
Could it have to do with the possibility the I had set
Seems likely. If events are enabled the workbook_open event should fire no
matter how many times a workbook is opened and closed.


--
Jim
| Hi Guys:
|
|
|
| A quick question on the "Workbook Open" event: When I load up Excel and
open
| the workbook, this event triggers. If I then close the workbook, without
| closing Excel, then open the workbook, it does not occur. Close down the
| worksheet and Excel, then open it, it triggers.
|
| Is this normal operation?
|
| Could it have to do with the possibility the I had set
| Application.EnableEvents = False, before exiting the workbook.
|
|
|
| Craig
|
|
 
Back
Top