Posted to microsoft.public.excel.programming

Susan[_3_] Susan[_3_] is offline

external usenet poster

Posts: 2

Execute a menu command with VBA?

Is it possible to execute a menuitem from the standard Excel menu with VBA code?

I have tried this (and several variations) with no luck:
MenuBars(xlWorksheet).Menus("Data").MenuItems("For m...").Execute

I am trying to open the Data form in the above code but I would like to do other things to.

And, for general knowledge, is "Commandbars" interchangeable with "MenuBars"?

Thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How disable menu command	Armangelo	Excel Discussion (Misc queries)	0	February 1st 06 10:00 AM
Name command in Insert Menu	Ahmad Wali Zahid	Excel Discussion (Misc queries)	1	January 31st 06 08:37 AM
How do I execute buttons in Excel using a voice command?	Rick Drabek	Excel Discussion (Misc queries)	0	November 11th 05 10:01 PM
How do I execute command from button or hyperlink?	rerhart	Excel Discussion (Misc queries)	1	February 18th 05 09:41 PM
Execute a command line app but i want a string returned.	dei	Excel Programming	0	October 23rd 03 08:18 AM

All times are GMT +1. The time now is 09:39 PM.

About Us

"It's about Microsoft Excel"