Weird Shortcut Key Problem.

[billbell52]

I developed an Excel Addin over the last several years (requirements
creep). It has about 10 shortcut keys. The shortcut keys have worked
in Excel 2000 and Excel 2003. Currently all users of the app use
Excel 2003. The app I have has grown in size over the years. It has
about 18,000 lines of code now. With this latest edition the shortcut
keys stopped working. The recent addition has nothing to do with the
shortcut keys. The shortcut keys remain the same value as Excel sets
them. For example Cntl-i stays as change Italics state. I single step
through the code and it executes and no error occurs. It appears to be
related to some memory limit in Excel. I get no errors that there is a
memory problem. I looked for someway to determine what the Shortcut
key was set to but I could not find a way to do this.

Example setting of Shortcut key. ShortCutGradeAll is a VBA subroutine.


Application.MacroOptions Macro:="ShortCutGradeAll", _
HasShortcutKey:=True, ShortcutKey:="G"

Questions:

1. Is there a way to read what the Shortcut key is set to? I could not
find one.
2. I would like to track down any memory related issues with the addin.
Any recommendations.

 

[awaters]

Try using Excel.Application.OnKey instead?

 

[billbell52]

It works. Did not know to look for this function...thanks.

I am still a little concerned why the other way stopped working.