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