BeforeClose Event problem
 

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

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

BeforeClose Event problem
 

Hi JLGWhiz,
That solution is not acceptable, sorry.
On the Workbook_Open event, the code creates a toolbar and on the
Workbook_BeforeClose event this toolbar is deleted. I cannot ask the user's
opinion about whether or not to keep the toolbar. This toolbar is only useful
for this application (and is necessary) and it must be deleted if the
application is closed.
I want to know if there is some way (Windows API maybe) to detect the click
on the Cancel button in the Excel close window form.
Thanks anyway and have a good day.
--
Jac Tremblay


"JLGWhiz" wrote:

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