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.

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
--
Earl Kiosterud
www.smokeylake.com

"Trebor Retrac" wrote in message
...
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.

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

Bob Carter
Douglas,MA USA

"Earl Kiosterud" wrote:

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
--
Earl Kiosterud
www.smokeylake.com

"Trebor Retrac" wrote in message
...
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.