Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default association of hot key with subroutine

Hello everybody,

I'd like to change the association of a makro (=subroutine) with a certain
hot key without having to go through the whole recording scheme again.

Can anyone give me a hint as to where that association can be edited?

thanks a lot for all your help!
Walter-U. Kellner


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default association of hot key with subroutine

Hi Walter,

From the menubar choose Tools, Macro, Macros. Select the macro from the
dialogue box list, for which you want to create a shortcut-key.
Then hit Options but and hit the key you which to use as a shortcut-key(used
in cojunction with the Control key). Click OK and then close the dialogue
box. That's it.

Paul

"Walter-U. Kellner" wrote in message
...
Hello everybody,

I'd like to change the association of a makro (=subroutine) with a certain
hot key without having to go through the whole recording scheme again.

Can anyone give me a hint as to where that association can be edited?

thanks a lot for all your help!
Walter-U. Kellner




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default association of hot key with subroutine

Walter,

Just click on Tools/Macro/Macros and in the window highlight the macr
you want to change. Then click on Options and associate your chose
letter there.

Regards

Seamu

--
Message posted from http://www.ExcelForum.com

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
Call a subroutine using variable subroutine name dhstein Excel Discussion (Misc queries) 3 July 26th 09 08:28 PM
association in excel hyperlink George Baitch Excel Discussion (Misc queries) 1 September 1st 05 12:00 PM
File Association need helpful advice Excel Discussion (Misc queries) 4 June 28th 05 09:07 PM
Data association Jeffrey Excel Worksheet Functions 5 January 24th 05 07:51 AM
Multiple combobox association Thunder5[_3_] Excel Programming 0 February 24th 04 12:51 PM


All times are GMT +1. The time now is 12:17 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"