LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 99
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
BeforeClose Event LeAnn Excel Programming 1 March 21st 08 11:10 PM
BeforeClose event help [email protected] Excel Programming 3 June 22nd 07 10:02 AM
BeforeClose Event JT Excel Programming 2 April 10th 07 03:52 PM
problem with beforeclose event Gordon Excel Programming 1 September 30th 04 11:21 PM
BeforeClose event - Savings Mike[_40_] Excel Programming 3 September 24th 03 11:33 AM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"