View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Johnny Mick[_2_] Johnny Mick[_2_] is offline
external usenet poster
 
Posts: 11
Default Keyboard Shortcuts

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