| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to restore a Custom menu if a user presses Cancel after selcting exit
A workbook has the subroutine attached to workbook: Private Sub Workbook_BeforeClose(Cancel As Boolean) Call DeleteMenu End Sub to delete custom menu before closing the workbook. However, if a user changes mind and presses Cancel to keep workbook open, the custom menu is deleted anyway! How do you solver this problem? Thank you. Alseikhan -- Alseikhan ------------------------------------------------------------------------ Alseikhan's Profile: http://www.excelforum.com/member.php...o&userid=32364 View this thread: http://www.excelforum.com/showthread...hreadid=529491 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cancel/Exit Sub | Excel Discussion (Misc queries) | |||
| Cancel an application exit from VBA? | Excel Programming | |||
| Cancel Macro is user selects 'cancel' at save menu | Excel Programming | |||
| how to Pause a VBA procedure until user presses Enter | Excel Programming | |||
| Cancel Exit on duplicate | Excel Programming | |||
![Alseikhan[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
