Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Custom Menus
Hi, I inherited an excel file that already has custom menus. I need
to delete a few menu commands from it and add another. I did this ans also assigned a macro to a button in the menu. It works fine until I save it and try to repoen the file. When I open it none of the custom menu revisions were made (however, the new macro that i wrote is still in the VBA editor). Can someone please let me know how to save the menu revisions? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Custom Menus
Perhaps the menu is being built dynamically.
Check in the ThisWorkbook code module and see if there is anything the Workbook_Open routine, or it calls another procedure. -- __________________________________ HTH Bob "ac1179" wrote in message ... Hi, I inherited an excel file that already has custom menus. I need to delete a few menu commands from it and add another. I did this ans also assigned a macro to a button in the menu. It works fine until I save it and try to repoen the file. When I open it none of the custom menu revisions were made (however, the new macro that i wrote is still in the VBA editor). Can someone please let me know how to save the menu revisions? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Custom Menus
On Jul 25, 3:09*pm, "Bob Phillips" wrote:
Perhaps the menu is being built dynamically. Check in the ThisWorkbook code module and see if there is anything the Workbook_Open routine, or it calls another procedure. -- __________________________________ HTH Bob "ac1179" wrote in message ... Hi, *I inherited an excel file that already has custom menus. *I need to delete a few menu commands from it and add another. *I did this ans also assigned a macro to a button in the menu. *It works fine until I save it and try to repoen the file. *When I open it none of the custom menu revisions were made (however, the new macro that i wrote is still in the VBA editor). *Can someone please let me know how to save the menu revisions? Thanks!- Hide quoted text - - Show quoted text - There's an auto_open procedure that has the line: Application.CommandBars("Main Menu").Visible = True When you exit out of the program there's another macro that runs that has the following line Application.CommandBars("Main Menu").Delete When I added new buttons to the "Main Menu" bar, I just saved the workbook normally (File Save As). Is there an option to save the latest changes in the "Main Menu" toolbar? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom menus don't appear under custom ribbon tab | Excel Programming | |||
Saving customized toolbar and menus | Excel Discussion (Misc queries) | |||
Custom FaceID's for Custom Menus | Excel Programming | |||
Custom faces for custom menus/commandbars | Excel Programming | |||
custom menus | Excel Programming |