On Wednesday, November 13, 2019 at 2:47:05 PM UTC-6, GS wrote:
On Tuesday, November 12, 2019 at 5:44:53 PM UTC-6, GS wrote:
Trying to learn VBA for Excel 2007. It would help if a macro could be
recorded from typing:

alt + LTRST

This results, when done "by hand" in the starting of an app in Excel.

I've tried to record this but no code results from it. Any suggestions?

Many thanks.

What "app in Excel"?
If it's a menuitem then use its "CommandBars("name").Control.Execute"
method.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Thanks for replying. I have an item on Excel 2007 menu bar named "EZ B".
Clicking on it produces another menu bar under it, and to get what I need I
click the button "Start" on this second menu bar.

It would be very helpful if you would post the script to replicate this
result from a VB macro.

Thanks again for helping me out.


Could

Excel 2007 doesn't have a menubar; - it has Ribbon tabs. If you are saying you
have an installed addin running that shows a menu on the Addins tab rather than
uses its own Ribbon tab then you need that menu's name or its ID. So... what's
the name of the addin? Can you access its code in the VBE?

--
Garry


Thanks again Garry. The row of drop-down buttons across the top of workbook reads

Data Review Page Layout Formulas Data Review View Exx EMS

Exx is an installed app designed to work with Excel.

When one clicks on Exx EMS an new row of buttons appears below, the first of which reads "Start". Clicking on it starts the app, which is what I need.

I can access VBA and set up the script. I just don't know the VBA commands to do what I want.

Thanks again for helping me out.