Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro short cut key
I have written a macro which uses Ctrl+r to run. I have no problems using
it on the computer that I created the macro on. When I move the macro to another computer, I cannot use Ctrl+r to run the macro despite the fact that Ctrl+r is mentioned in the macro and the Macro Options dialog box also shows the Shortcut key as being Ctrl+r for the macro! There are no other macros on that computer. Can someone please tell me how to setup Excel to use Ctrl+r to run the macro? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro short cut key
Maybe you should try (or maybe you meant to say) Ctrl+Shift+r
Ctrl+r is already reserved in Excel as a keyboard shortcut to <fill right D.S. "Vispy" wrote in message ... I have written a macro which uses Ctrl+r to run. I have no problems using it on the computer that I created the macro on. When I move the macro to another computer, I cannot use Ctrl+r to run the macro despite the fact that Ctrl+r is mentioned in the macro and the Macro Options dialog box also shows the Shortcut key as being Ctrl+r for the macro! There are no other macros on that computer. Can someone please tell me how to setup Excel to use Ctrl+r to run the macro? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Macro Short Cuts | Excel Discussion (Misc queries) | |||
Short Macro | Excel Discussion (Misc queries) | |||
ZED - Need a short macro fix | Excel Discussion (Misc queries) | |||
Onkey vs Macro Short cut key | Excel Discussion (Misc queries) | |||
how to enhance this macro (really short) | Excel Programming |