Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete menu
Hey guys
I have a menu called "SMS Functions" on the menu toolbar at the the top of Excel. Its next to the "Help" menu. How do I programmatically delete this menu item? Thank you Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete menu
application.CommandBars("Worksheet Menu Bar").Controls("SMS
Functions").Delete -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... Hey guys I have a menu called "SMS Functions" on the menu toolbar at the the top of Excel. Its next to the "Help" menu. How do I programmatically delete this menu item? Thank you Todd Huttenstine |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete menu
Thank you
-----Original Message----- application.CommandBars("Worksheet Menu Bar").Controls ("SMS Functions").Delete -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... Hey guys I have a menu called "SMS Functions" on the menu toolbar at the the top of Excel. Its next to the "Help" menu. How do I programmatically delete this menu item? Thank you Todd Huttenstine . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete menu
Todd,
Try - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sub TEST() Dim CTL As CommandBarControl For Each CTL In Application.CommandBars(1).Controls If Application.Trim(CTL.Caption) = "SMS Functions" Then CTL.Delete End If Next End Sub - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Regards, Soo Cheon Jheong _ _ ^ąŻ^ -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Menu Delete greyed out | Excel Worksheet Functions | |||
Can't delete menu button | Excel Discussion (Misc queries) | |||
How to delete item on right click menu? | Excel Discussion (Misc queries) | |||
help me. How to delete a menu | Excel Discussion (Misc queries) | |||
WorkBook_BeforeClose (Delete Menu) | Excel Programming |