Viewing/Editing/Error Checking KB shortcuts assigned to macros

[Conan Kelly]

MS Office XL 2003 (11.8169.8172) SP3
(Part of MS Office Professional Edition 2003)

Win XP Pro SP2



--
Hello all,

Is there any way to view/edit/check keyboard shortcut macro assignment
settings?

I am working on this file that is supposed to have some code assigned to
[Ctrl] + [Shift] + [T]. The first time I tried it, it seemed like it might
be working (there was a pause), and then the error handler executed
(displays a message box). I closed the file w/o saving (closed the file
only...did not close XL), reopened, made necessary changes, did my KB
shortcut, and this time, the error handler executed immediately.

This code runs just fine if I run it from VBA directly or from [Alt] + [F8]
in XL.

I thought I would check the code as it runs by putting breakpoints in/on
each sub. When I did my KB shortcut, it did not break into code anywhere.
It just ran the error hanler.

I was thinking that my KB shortcut is not tied to my code, but some other
code in the file, although I do not see any other code in the file anywhere.

Is there anyway to check what code the KB shortcut is assigned to or change
what it is assigned to.

Thanks for any help anyone can provide,

Conan Kelly

 

[Jim Rech]

See this tip:

http://www.dailydoseofexcel.com/archives/2007/01/05/macro-shortcut-keys/