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

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

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