Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weird Shortcut Key Problem.
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weird Shortcut Key Problem.
Try using Excel.Application.OnKey instead?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weird Shortcut Key Problem.
It works. Did not know to look for this function...thanks.
I am still a little concerned why the other way stopped working. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weird problem | Setting up and Configuration of Excel | |||
Weird problem | Excel Worksheet Functions | |||
Weird Problem | Excel Worksheet Functions | |||
Weird problem! | Excel Programming | |||
Weird VBA problem | Excel Programming |