Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a menu item
I have a custom add in for work that adds another menu at the top of my
excel. I want to write a macro that includes calling an item in that menu. When I record a macro and go to the item i need, it functions properly (resets a bunch of dde links) but it doesn't record the code. Anyone know of a way to call something in a menu by it's name or maybe reset all the dde links on a worksheet? Thanks in advance, David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a menu item
You can do it with code like
Application.CommandBars.ActiveMenuBar.Controls("Me nuName"). _ Controls("ItemName").Execute -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "dkaydkay" wrote in message ... I have a custom add in for work that adds another menu at the top of my excel. I want to write a macro that includes calling an item in that menu. When I record a macro and go to the item i need, it functions properly (resets a bunch of dde links) but it doesn't record the code. Anyone know of a way to call something in a menu by it's name or maybe reset all the dde links on a worksheet? Thanks in advance, David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a menu item
Hi dkaydkay
You can use Execute Application.CommandBars("???").Controls("??").Exec ute -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dkaydkay" wrote in message ... I have a custom add in for work that adds another menu at the top of my excel. I want to write a macro that includes calling an item in that menu. When I record a macro and go to the item i need, it functions properly (resets a bunch of dde links) but it doesn't record the code. Anyone know of a way to call something in a menu by it's name or maybe reset all the dde links on a worksheet? Thanks in advance, David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a menu item
THANKS! Works great!
"Chip Pearson" wrote: You can do it with code like Application.CommandBars.ActiveMenuBar.Controls("Me nuName"). _ Controls("ItemName").Execute -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "dkaydkay" wrote in message ... I have a custom add in for work that adds another menu at the top of my excel. I want to write a macro that includes calling an item in that menu. When I record a macro and go to the item i need, it functions properly (resets a bunch of dde links) but it doesn't record the code. Anyone know of a way to call something in a menu by it's name or maybe reset all the dde links on a worksheet? Thanks in advance, David |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a menu item
Thanks!
"Ron de Bruin" wrote: Hi dkaydkay You can use Execute Application.CommandBars("???").Controls("??").Exec ute -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dkaydkay" wrote in message ... I have a custom add in for work that adds another menu at the top of my excel. I want to write a macro that includes calling an item in that menu. When I record a macro and go to the item i need, it functions properly (resets a bunch of dde links) but it doesn't record the code. Anyone know of a way to call something in a menu by it's name or maybe reset all the dde links on a worksheet? Thanks in advance, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding a,b,c,etc to end of item in call | Excel Discussion (Misc queries) | |||
Add menu item to right-click menu | Excel Programming | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming |