Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard Shortcuts
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard Shortcuts
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 ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard Shortcuts
Johnny,
Thanks for the info. That is exactly what I'm looking for. Conan |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard Shortcuts
Gary's Student
Thanks for the info. That will come in handy. Conan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcuts | Excel Discussion (Misc queries) | |||
Keyboard Shortcuts | Excel Discussion (Misc queries) | |||
Keyboard shortcuts | Excel Discussion (Misc queries) | |||
KEYBOARD SHORTCUTS | Excel Discussion (Misc queries) | |||
Keyboard Shortcuts | Excel Programming |