Keyboard Shortcuts

[Conan Kelly]

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

[Johnny Mick]

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
>
>
>

[Gary''s Student]

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
>
>
>

[Tom Ogilvy]

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:[email protected]...
> 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
>
>

[Conan Kelly]

Gary's Student

Thanks for the info. That will come in handy.

Conan

[Conan Kelly]

Johnny,

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

Conan