View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Recording a VBA Macro from keystrokes

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