Excel 2003 - VBA - Workbook Open Event

[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

 

[Don Guillett]

Also put in
sub auto_open()

 

[Jim Rech]

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
|
|