Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some code that runs during the Workbook_BeforeClose procedure. I
have a Main Menu menu bar that I want to remove when the user closes the workbook. The code works with out problem, but, if the user is prompted to save the workbook before closing AND Cancel is clicked, the menu is removed but the workbook is still open, the user then does not have access to the menu options. I am trying to figure out a way to invoke code that will rebuild the menu bar if the user clicks Cancel at the save workbook dialog box. Does anyone know how to capture the Cancel event of the save workbook procedure? TIA RC- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect "Copy" and "Save As" changes to workbook | Excel Discussion (Misc queries) | |||
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Discussion (Misc queries) | |||
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Worksheet Functions | |||
save and restore "Workbook Menu Bar" & "Cell" menus | Excel Programming | |||
Close workbook with "Cancel=TRUE" in the BeforeClose()" | Excel Programming |