![]() |
Ctl-X activation of macros
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 |
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 |
All times are GMT +1. The time now is 03:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com