How to get out of BeforeClose event without closing?
Excel 2002
Windows XP Pro SP 2
I am trying to simulate one of those "Do you really, REALLY want to close
this workbook" messages when a user tries to close a workbook. I am using a
message box with the vbYesNo constant and I can successfully determine if
Yes or No was clicked. If the user selects "No", which in my case would be
to NOT close the workbook, how do I get out of the BeforeClose event without
closing?
All help appreciated.
Thanks!
-gk-
=================================================
The creative act is not the province of remote oracles or rarefied geniuses
but a transparent process that is open to everyone.
-Greg Kot in Wilco Learning How To Die-
|