Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wrote an add-in which I load on the Workbook_Open event, and close on the
Workbook_BeforeClose event. I just noticed that if you go to close the file, but then hit Cancel, so you're still in the file, my Add-In has been unloaded. This means that the BeforeClose event is firing prior to the pressing of the Cancel button, which then keeps the workbook open. It's not a huge deal, but, someone will likely see this as a bug, if I leave it this way. Ideas on how to trap the press of the Cancel button, and reload the Add-In? I'm not sure that's most efficient, though... I'd rather not unload the Add-In until the workbook is really going to close. Ideas? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Before Close Event Hide all Worksheets then Close Application | Excel Programming | |||
before close event with condition | Excel Discussion (Misc queries) | |||
Before Close event | Excel Programming | |||
Worksheet close event? | Excel Programming | |||
After Close Event? | Excel Programming |