View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
programmernovice[_2_] programmernovice[_2_] is offline
external usenet poster
 
Posts: 61
Default Recording a VBA Macro from keystrokes

On Wednesday, November 13, 2019 at 4:11:50 PM UTC-6, GS wrote:
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.


Ok, so it's an addin that provides its own tab on the Ribbon!

VBA will require some way to execute whatever code you have, so how exactly do
you want this to work?

Why do you want an alternative way to start the app when it gives you an easy
way already?


You are right of course. I was just looking for a little additional automation, to do it via auto_open when I start Excel.



Why not just give existing menuitem a keyboard shortcut (if xlam)?


One is available via alt_{various letters). I can certainly use that.


A good source for how to access Ribbon menus is here...

http://www.rondebruin.nl/win/section2.htm


I will look up the source you sent me.

Thanks, Garry, for taking time to help me out.