Basically there's a custom menu item with sub-items which I need to
automate. I don't have the macros attached to it though. The Data
Sort was just an example which I mentioned.

Thanks for the response Bob.

Mangesh



On 21 Oct, 13:52, "Bob Phillips" wrote:
Why not just run a VBA sort?

--
__________________________________
HTH

Bob

"Mangesh" wrote in message

...



I am trying to run a sub menu item from the toolbar through VBA. How
do i do it? Lets say for example, i want to run Data Sort.

CommandBars("Worksheet Menu Bar").Controls("Data").Index gives me the
index of menu item 'Data'. But how to get the index for Sort.

something like this is what i am looking for, although this is not
valid
CommandBars("Worksheet Menu Bar").Controls("Data").Controls("Sort")

Basically i want to automate one of the submenu actions.

Mangesh- Hide quoted text -

- Show quoted text -