Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2006

Tip: Looking for answers? Try searching our database.

Weird Shortcut Key Problem.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
billbell52 - 22 Mar 2006 00:23 GMT
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@linnhoffmarch.com - 22 Mar 2006 10:50 GMT
Try using Excel.Application.OnKey instead?
billbell52 - 22 Mar 2006 21:53 GMT
It works.  Did not know to look for this function...thanks.

I am still a little concerned why the other way stopped working.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.