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

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

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

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

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