I would like to be able to change the shortcut key in an EXCEL macro without
having to re-write the whole macro.
Any help is appreciated.
Thank you.
--
TonyB

select the macro in Tolls=>Macros=>Macros and select Options. Change it in
the dialog.

--
Regards,
Tom Ogilvy



"Tony Borg" wrote:

> I would like to be able to change the shortcut key in an EXCEL macro without
> having to re-write the whole macro.
> Any help is appreciated.
> Thank you.
> --
> TonyB

Hi Tom,
Thanks for your prompt reply. I had actually tried that before. When I first
recorded the macro a screen came up saying "Could not record" or similar.
However, when I viewed the macro the info was all there. The macro would not
run with the shortcut I had picked initially but it worked exactly as
required when I used the 'Run' command. I thought I had picked a "Reserved"
shortcut or something. I changed it again when I received your reply but it
is still the same. It will only work when I use the 'Run' command. If you
have any further ideas it/they would be gratefully received.
Regards
Tony Borg
--
TonyB


"Tom Ogilvy" wrote:

> select the macro in Tolls=>Macros=>Macros and select Options. Change it in
> the dialog.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Tony Borg" wrote:
>
> > I would like to be able to change the shortcut key in an EXCEL macro without
> > having to re-write the whole macro.
> > Any help is appreciated.
> > Thank you.
> > --
> > TonyB

Are you paying attention to the case of the letter?

you can also use the OnKey function to assign it to a shortcut key for that
instance of excel.

Using Run has nothing to do with the shortcut key.

--
Regards,
Tom Ogilvy


"Tony Borg" <(E-Mail Removed)> wrote in message
news91398A5-1A78-4712-AEF6-(E-Mail Removed)...
> Hi Tom,
> Thanks for your prompt reply. I had actually tried that before. When I
> first
> recorded the macro a screen came up saying "Could not record" or similar.
> However, when I viewed the macro the info was all there. The macro would
> not
> run with the shortcut I had picked initially but it worked exactly as
> required when I used the 'Run' command. I thought I had picked a
> "Reserved"
> shortcut or something. I changed it again when I received your reply but
> it
> is still the same. It will only work when I use the 'Run' command. If you
> have any further ideas it/they would be gratefully received.
> Regards
> Tony Borg
> --
> TonyB
>
>
> "Tom Ogilvy" wrote:
>
>> select the macro in Tolls=>Macros=>Macros and select Options. Change it
>> in
>> the dialog.
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>>
>> "Tony Borg" wrote:
>>
>> > I would like to be able to change the shortcut key in an EXCEL macro
>> > without
>> > having to re-write the whole macro.
>> > Any help is appreciated.
>> > Thank you.
>> > --
>> > TonyB