View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default BeforeClose Event problem

This is one way, lacking any other information about the objective.
You could put in a message box just before the delete line and ask if the
user wants to continue the delete. If they choose not to delete, you would
need a GoTo to some other part of the code to get them out of the before
close procedure.

"Jac Tremblay" wrote:

Hi,
On the BeforeClose event, I delete the command button and toolbar specific
to the application. These controls are created in the Workbook_Open event.
When the user clicks the Excel close button and cancels his action, the
BeforeClose event has already fired and the toolbar has been deleted.
What can I do? Is it possible to avoid this delete somehow? Can one catch
the Cancel button in the close message from Excel?
I could recreate the controls in that particular case, but where?
Thanks.
--
Jac Tremblay