ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Ctl-X activation of macros (https://www.excelbanter.com/excel-programming/279873-ctl-x-activation-macros.html)

John Baker

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

Tim[_28_]

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