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

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