How to know when a shortcut key is already assigned

  • Thread starter Thread starter j_mcarthur
  • Start date Start date
J

j_mcarthur

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,

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
 
Back
Top