Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook where I have overridden several of the CommandBarButtons on
the standard "Workbook Menu Bar" and "Cell" CommandBars. I have taken the drastic measure of resetting "Workbook Menu Bar" and "Cell" CommandBars prior to making my changes and then resetting again in the Workbook_Deactivate sub. I've taken this measure to prevent errors if for some reason the particular CommandBarButtons that I'm changing are Nothing or Not Enabled etc. This of coarse wipes out any customizations my users might have made to their Menus, probably making them not happy. I would like to somehow save the state of the "Workbook Menu Bar" and "Cell" CommandBars on entry to my workbook and then restore it on Workbook_Deactivate but I cannot figure out how. Can someone tell me how to accomplish this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect "Copy" and "Save As" changes to workbook | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions |