| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute a menu command with VBA?
Dick Kusleika wrote:
Susan MenuBars probably still works, but it's the old way. It's not completely interchangeable with Commandbars because toolbars are commandbars, but not menubars. I think the problem with your code is that xlWorksheet isn't a proper index of a menu. Try this Sheet1.ShowDataForm If you want to use the menu, it would look like this CommandBars(1).Controls("Data").Controls("Form..." ).Execute Thanks, Dick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How disable menu command | Excel Discussion (Misc queries) | |||
| Name command in Insert Menu | Excel Discussion (Misc queries) | |||
| How do I execute buttons in Excel using a voice command? | Excel Discussion (Misc queries) | |||
| How do I execute command from button or hyperlink? | Excel Discussion (Misc queries) | |||
| Execute a command line app but i want a string returned. | Excel Programming | |||
![Susan[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
