Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BeforeClose Event | Excel Programming | |||
BeforeClose event help | Excel Programming | |||
BeforeClose Event | Excel Programming | |||
problem with beforeclose event | Excel Programming | |||
BeforeClose event - Savings | Excel Programming |