How to know when a shortcut key is already assigned

When recording a macro in Word the dialog box that lets you assign a
shortcut key to the new macro shows you if any other command is
presently assigned to the key combination you'd like to choose. The
equivalent dialog box in Excel is different from the one in Word and
does not appear to have this useful feature. Hence you may unknowingly
override some built-in command when assigning a shortcut key to a macro
in excel. Word also has a nifty feature whereby you can produce a
listing of all the built-in commands, along with there currently
assigned shortcut keys. Excel does not seem to have this feature
either. So, is there any way of finding out whether a shortcut key
you're thinking of using for a macro is already assigned to another
excel command or function?

Joe

I think the easiest thing is to try the proposed shortcut keys and see what
happens.

Chip Pearson has a list of shortcut keys:
http://www.cpearson.com/excel/ShortCuts.htm

David McRitchie has one:
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Debra Dalgleish has one:
http://www.contextures.com/excel.htm


[email protected] wrote:
>
> When recording a macro in Word the dialog box that lets you assign a
> shortcut key to the new macro shows you if any other command is
> presently assigned to the key combination you'd like to choose. The
> equivalent dialog box in Excel is different from the one in Word and
> does not appear to have this useful feature. Hence you may unknowingly
> override some built-in command when assigning a shortcut key to a macro
> in excel. Word also has a nifty feature whereby you can produce a
> listing of all the built-in commands, along with there currently
> assigned shortcut keys. Excel does not seem to have this feature
> either. So, is there any way of finding out whether a shortcut key
> you're thinking of using for a macro is already assigned to another
> excel command or function?
>
> Joe

--

Dave Peterson

Dave,

I was going to suggest that, but wondered how it'd be taken. It reminds me
of the radio ads years ago when 7-11 started staying open 24 hours a day.
"How do you tell which 7-11 stores are the ones that are open 24 hours a
day?" "Easy -- they're the ones with the lights on at 2 O'Clock in the
morning."

Earl Kiosterud
www.smokeylake.com

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
>I think the easiest thing is to try the proposed shortcut keys and see what
> happens.
>
> Chip Pearson has a list of shortcut keys:
> http://www.cpearson.com/excel/ShortCuts.htm
>
> David McRitchie has one:
> http://www.mvps.org/dmcritchie/excel/shortx2k.htm
>
> Debra Dalgleish has one:
> http://www.contextures.com/excel.htm
>
>
> [email protected] wrote:
>>
>> When recording a macro in Word the dialog box that lets you assign a
>> shortcut key to the new macro shows you if any other command is
>> presently assigned to the key combination you'd like to choose. The
>> equivalent dialog box in Excel is different from the one in Word and
>> does not appear to have this useful feature. Hence you may unknowingly
>> override some built-in command when assigning a shortcut key to a macro
>> in excel. Word also has a nifty feature whereby you can produce a
>> listing of all the built-in commands, along with there currently
>> assigned shortcut keys. Excel does not seem to have this feature
>> either. So, is there any way of finding out whether a shortcut key
>> you're thinking of using for a macro is already assigned to another
>> excel command or function?
>>
>> Joe
>
> --
>
> Dave Peterson

Or Steven Wright walking toward a store that said "open 24 hours" and noticing
that the shopkeeper was closing.

I thought you were open 24 hours.
Not in a row!

http://www.fortogden.com/fosw.html

Earl Kiosterud wrote:
>
> Dave,
>
> I was going to suggest that, but wondered how it'd be taken. It reminds me
> of the radio ads years ago when 7-11 started staying open 24 hours a day.
> "How do you tell which 7-11 stores are the ones that are open 24 hours a
> day?" "Easy -- they're the ones with the lights on at 2 O'Clock in the
> morning."
>
> Earl Kiosterud
> www.smokeylake.com
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> >I think the easiest thing is to try the proposed shortcut keys and see what
> > happens.
> >
> > Chip Pearson has a list of shortcut keys:
> > http://www.cpearson.com/excel/ShortCuts.htm
> >
> > David McRitchie has one:
> > http://www.mvps.org/dmcritchie/excel/shortx2k.htm
> >
> > Debra Dalgleish has one:
> > http://www.contextures.com/excel.htm
> >
> >
> > [email protected] wrote:
> >>
> >> When recording a macro in Word the dialog box that lets you assign a
> >> shortcut key to the new macro shows you if any other command is
> >> presently assigned to the key combination you'd like to choose. The
> >> equivalent dialog box in Excel is different from the one in Word and
> >> does not appear to have this useful feature. Hence you may unknowingly
> >> override some built-in command when assigning a shortcut key to a macro
> >> in excel. Word also has a nifty feature whereby you can produce a
> >> listing of all the built-in commands, along with there currently
> >> assigned shortcut keys. Excel does not seem to have this feature
> >> either. So, is there any way of finding out whether a shortcut key
> >> you're thinking of using for a macro is already assigned to another
> >> excel command or function?
> >>
> >> Joe
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson