View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim[_28_] Tim[_28_] is offline
external usenet poster
 
Posts: 1
Default Ctl-X activation of macros

As for option 2, you should be able to do this:
Goto the menu: ToolsMacros...Macros

This gives the Macro window with the list of macros available and a
bunch of buttons on the right side. Select the macro you want to
assign the key combo to, and click the last button in the list,
"Options...".

That gives the "Macro Options" window with a field for a shortcut key
combination.

Hope that works for you,
Tim

John Baker wrote in message . ..
Hi:

Does anyone know a way to set up macro button so that either:

1. It can be activated by entering the first letter of the button name (assuming the
button is in the active window);

OR
2.It can be activated by a "crl-X" type entry.

I need this in order to make the process simpler and potentially so that it can be
activated by a global (keyboard) macro or program.

Regards

John Baker