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