View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default identifying shortcut keys associated with custom macros

Tim Childs posted a routine that seemed to work for him in xl2002 (but he said
that it didn't in xl2k--no info on xl97):

http://groups.google.com/groups?&thr...%40tkmsftngp07

(maybe you could find someone with xl2002 and have them try it for you.)

windsurferLA wrote:

In Excel95 or Excel97 is there a way to obtain a list of all the
keyboard shortcuts that have been assigned to custom macros?

I have an Excel based application that has over a 100 macros, many of
which are associated with keyboard shortcuts. Unfortunately, as this
tool has been developed over the years, I have not kept track of which
keys were assigned to which macros. I note that when I hit a certain
key board combination by accident, the program executes a macro. I want
to find out which macro is being executed without having to investigate
each of the macros individually.


--

Dave Peterson