Keyboard Shortcuts

Hello All,

Is there any way (other than when recording macros) to manually go in and set (or change) keyboard shortcuts on existing macros?

TIA,

Conan Kelly

Hello,
If I understand, you want to create a 'ctrl-*' shortcut key to a macro
that's already been created. If this is the case, from the spreadsheet that
has the macro, select 'Alt-F8'. This brings up the list of macros attached
to that spreadsheet. Highlight the macro you want to create the shortcut.
At the bottom of that window, select 'Options'. A second window pops up, and
this is the point where you can select a 'Ctrl' key to create your shortcut.
Hope this is what you were looking for.

Regards,
Johnny Mick

"Conan Kelly" wrote:

> Hello All,
>
> Is there any way (other than when recording macros) to manually go in and set (or change) keyboard shortcuts on existing macros?
>
> TIA,
>
> Conan Kelly
>
>
>

Sub Macro2()
Application.MacroOptions Macro:="Macroxx", ShortcutKey:="e"
End Sub


will set the shortcutkey for Macroxx to CNTRL-e
--
Gary's Student


"Conan Kelly" wrote:

> Hello All,
>
> Is there any way (other than when recording macros) to manually go in and set (or change) keyboard shortcuts on existing macros?
>
> TIA,
>
> Conan Kelly
>
>
>

select the macro in Tools=>Macro=>Macros and then click the option button.

--
Regards,
Tom Ogilvy


"Conan Kelly" <CTBarbarin at msn dot com> wrote in message
news:OB9ocyIPGHA.3276@TK2MSFTNGP09.phx.gbl...
> Hello All,
>
> Is there any way (other than when recording macros) to manually go in and
set (or change) keyboard shortcuts on existing macros?
>
> TIA,
>
> Conan Kelly
>
>

Gary's Student

Thanks for the info. That will come in handy.

Conan

Johnny,

Thanks for the info. That is exactly what I'm looking for.

Conan