Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 98
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
activation key LewisT Excel Discussion (Misc queries) 2 March 24th 10 05:27 AM
Activation Request Harry Excel Discussion (Misc queries) 2 September 15th 07 05:22 AM
Sheet activation CWillis Excel Discussion (Misc queries) 5 June 1st 06 09:50 PM
Excel macro activation. Dick Kusleika Excel Programming 0 July 29th 03 04:47 PM
Excel macro activation. Dave Ramage[_2_] Excel Programming 0 July 29th 03 04:47 PM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"