Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
activation key | Excel Discussion (Misc queries) | |||
Activation Request | Excel Discussion (Misc queries) | |||
Sheet activation | Excel Discussion (Misc queries) | |||
Excel macro activation. | Excel Programming | |||
Excel macro activation. | Excel Programming |