Hi
Is there a way to assign shortcut keys with some code? I know when you record a macro it askes you if you would like to assign a shortcut. any idea and is so is there a way to update the shortcut keys?
many thanks
Hi
Is there a way to assign shortcut keys with some code? I know when you record a macro it askes you if you would like to assign a shortcut. any idea and is so is there a way to update the shortcut keys?
many thanks
I tried to record as a macro assigning a hot key to an other macro and I got
this:
Application.MacroOptions Macro:="Macroname", Description:= _
"Recorded by MyName, date: 10/13/2005.", ShortcutKey:="r"
Stefi
"funkymonkUK" wrote:
>
> Hi
>
> Is there a way to assign shortcut keys with some code? I know when you
> record a macro it askes you if you would like to assign a shortcut. any
> idea and is so is there a way to update the shortcut keys?
>
> many thanks
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=475729
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks