Workbook_Open() events won't run

Following the logic in the ExitWorkbook() procedure:

1) you disable events
2) you enable alerts
3) you reset a toolbar back to its state before the workbook_open event was run
4) then close the workbook

What seems to be missing is a statement that reenables events. While this isn't my programming expertise, I suspect that, as long as Excel remains open after this procedure is run, events will remain disabled. When Excel is closed and reopened, the enableevents toggle is reset back to true.

Again, this isn't my expertise, so I'm not sure if it is as simple as adding an application.enableevents=true statement to the end. It seems that events are remaining disabled because you never tell Excel to reenable events.

@MrShorty: what it says on the tin Application.EnableEvents = False

.EnableEvents is an Application level property so, if you set it False, you must set it back to True at some point within the instance of Excel otherwise NO events will fire.

You're welcome. Thanks for the rep.