| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Popup Menu Control
I am trying to program a custom menu for an Excel application, and so far I
have managed to move the File menu to the end of the list and have multiple File menus with only three having the MenuItems in them. How do I rearrange the menu order and remove the unwanted File menus? James |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Popup Menu Control
Hi James,
Try: '=========== Public Sub Tester Application.CommandBars("Worksheet Menu Bar").Reset End Sub '<<=========== --- Regards, Norman "James" wrote in message ... I am trying to program a custom menu for an Excel application, and so far I have managed to move the File menu to the end of the list and have multiple File menus with only three having the MenuItems in them. How do I rearrange the menu order and remove the unwanted File menus? James |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Popup Menu Control
James:
only Reset the File menus Dim cbr As CommandBarControl For Each cbr In Application.CommandBars.FindControls(ID:=30002) MsgBox cbr.Caption cbr.Reset Next -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "James" wrote: I am trying to program a custom menu for an Excel application, and so far I have managed to move the File menu to the end of the list and have multiple File menus with only three having the MenuItems in them. How do I rearrange the menu order and remove the unwanted File menus? James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Popup Menu / Shortcut Menu | Excel Discussion (Misc queries) | |||
| Disable popup menu | Excel Programming | |||
| Popup Menu | Excel Programming | |||
| Control IE popup from excel VBA instantiation | Excel Programming | |||
| add combo box at popup menu | Excel Programming | |||
Linear Mode
