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

You can do it with code like


Application.CommandBars.ActiveMenuBar.Controls("MenuName"). _
Controls("ItemName").Execute



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"dkaydkay" <(E-Mail Removed)> wrote in message
news:28680021-9A2B-4430-BF8E-(E-Mail Removed)...
>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

Hi dkaydkay

You can use Execute

Application.CommandBars("???").Controls("??").Execute


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"dkaydkay" <(E-Mail Removed)> wrote in message news:28680021-9A2B-4430-BF8E-(E-Mail Removed)...
>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

THANKS! Works great!

"Chip Pearson" wrote:

> You can do it with code like
>
>
> Application.CommandBars.ActiveMenuBar.Controls("MenuName"). _
> Controls("ItemName").Execute
>
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
> (email address is on the web site)
>
>
> "dkaydkay" <(E-Mail Removed)> wrote in message
> news:28680021-9A2B-4430-BF8E-(E-Mail Removed)...
> >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
>
>
>

Thanks!

"Ron de Bruin" wrote:

> Hi dkaydkay
>
> You can use Execute
>
> Application.CommandBars("???").Controls("??").Execute
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "dkaydkay" <(E-Mail Removed)> wrote in message news:28680021-9A2B-4430-BF8E-(E-Mail Removed)...
> >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
>