Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Aborting Excel Exit
I have a fairly large Excel VBA Application (3MB) which
loads as an add-in. Since it takes a fair amount of time to load oer the network whenever users start Excel, users have requested that I add a Message Box to ask them if they really want to exit Excel as sometimes they simply want to close a workbook but inadvertently close Excel which requires reloading the 3MB add-in. I can display the MsgBox using the Auto_Close procedure but cannot seem to figure out how to keep Excel from exiting should the user indicate they do not want to exit. Does anyone know how I can cancel the exit from within the add-in? Thanks. Frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Aborting Excel Exit
Nevermind, I solved it using Events
-----Original Message----- I have a fairly large Excel VBA Application (3MB) which loads as an add-in. Since it takes a fair amount of time to load oer the network whenever users start Excel, users have requested that I add a Message Box to ask them if they really want to exit Excel as sometimes they simply want to close a workbook but inadvertently close Excel which requires reloading the 3MB add-in. I can display the MsgBox using the Auto_Close procedure but cannot seem to figure out how to keep Excel from exiting should the user indicate they do not want to exit. Does anyone know how I can cancel the exit from within the add-in? Thanks. Frank . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to exit Excel | Excel Worksheet Functions | |||
Aborting save | Excel Discussion (Misc queries) | |||
Excel 07 won't exit | Setting up and Configuration of Excel | |||
exit excel | Excel Discussion (Misc queries) | |||
aborting a sub | Excel Programming |