Disassociate existing macro from control key and execute by botton

[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.

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

"Trebor Retrac" <TreborRetrac@discussions.microsoft.com> wrote in message
news:904F804C-3914-4079-ADC3-D1170A75955D@microsoft.com...
>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 Retrac]

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" <TreborRetrac@discussions.microsoft.com> wrote in message
> news:904F804C-3914-4079-ADC3-D1170A75955D@microsoft.com...
> >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.
>
>
>