Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot Save XLA add-in menus
Hi,
Please help if anyone knows the solution to this problem? I have created an XLA, which creates menu item "Test" between Window & Help menu item in Excel when we add the XLA add-in to Excel XLS file. After XLA is added, I save XLS file and close it. When I open it again, I see the menu item "Test", but dont see the sub-menu items under it. Why are the sub-menu items getting deleted?? And thus I'm not able to properly save XLA within my XLS file. Delete Menu Code: Application.CommandBars("Worksheet Menu Bar").Controls("&MW Focused Cal").Delete Thanks in advance. - Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot Save XLA add-in menus
Oh sorry, typo in code. here it goes again.
Delete Menu Code: Application.CommandBars("Worksheet Menu Bar").Controls("&Test").Delete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub-menus of main menus for Excel 2007 | New Users to Excel | |||
difference between word 2003 menus and word 2007 menus-Explain pl | Excel Discussion (Misc queries) | |||
New Menus - attaching but menus are reset | Excel Worksheet Functions | |||
save and restore "Workbook Menu Bar" & "Cell" menus | Excel Programming | |||
Overriding Actions of Excel DropDown Menus and Poup Menus | Excel Programming |