K
ksnapp
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
thing on an existing sub but it doesn't take
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Wright
Tools / Macro / Macros / Select Macro and then hit the Options button and put in
the shortcut you want
the shortcut you want
K
ksnapp
that doesn't wor
J
JE McGimpsey
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?
you get an error, nothing? a crash?
What keys are you trying to assign? Where is your macro stored?
K
ksnapp
sorry i could have been more specific. it just sits there, nothin
happens when i hit the assigned key combinatio
happens when i hit the assigned key combinatio
J
JE McGimpsey
ksnapp said:sorry i could have been more specific. it just sits there, nothing
happens when i hit the assigned key combination
Try putting a breakpoint in your code to see if it's getting called.