Disassociate existing macro from control key and execute by botton

T

Trebor Retrac

I wish to change execution of a existing macro from a control key to a button.
I do no want to rewrite the macro.
I have assigned the macro to the button but the control key still has the
capaibility of executing the macro.
 
E

Earl Kiosterud

Trebor,

If the control key is a shortcut (not assigned via the OnKey method), try
this:

Tools - Macro - Macros. Select your macro, click Options. Remove the
shortcut letter from the box. OK
 
T

Trebor Retrac

Thanks Earl:
This process worked.
I could not get the options to display when I used VB Editor.

Bob Carter
Douglas,MA USA
 
Top