K ksnapp Mar 3, 2004 #1 can i assign hot keys to vba sub? i have been trying throught the macr thing on an existing sub but it doesn't take
can i assign hot keys to vba sub? i have been trying throught the macr thing on an existing sub but it doesn't take
K Ken Wright Mar 3, 2004 #2 Tools / Macro / Macros / Select Macro and then hit the Options button and put in the shortcut you want
Tools / Macro / Macros / Select Macro and then hit the Options button and put in the shortcut you want
J JE McGimpsey Mar 4, 2004 #4 and that is not particularly helpful. What does "doesn't work" mean - do you get an error, nothing? a crash? What keys are you trying to assign? Where is your macro stored?
and that is not particularly helpful. What does "doesn't work" mean - do you get an error, nothing? a crash? What keys are you trying to assign? Where is your macro stored?
K ksnapp Mar 4, 2004 #5 sorry i could have been more specific. it just sits there, nothin happens when i hit the assigned key combinatio
sorry i could have been more specific. it just sits there, nothin happens when i hit the assigned key combinatio
J JE McGimpsey Mar 4, 2004 #6 ksnapp said: sorry i could have been more specific. it just sits there, nothing happens when i hit the assigned key combination Click to expand... Try putting a breakpoint in your code to see if it's getting called.
ksnapp said: sorry i could have been more specific. it just sits there, nothing happens when i hit the assigned key combination Click to expand... Try putting a breakpoint in your code to see if it's getting called.
