Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2011, 05:52 PM
judicial85 judicial85 is offline Num Lock ERROR Windows 7 Num Lock ERROR Office 2010 (Version 14.0)
Advanced Beginner
Num Lock ERROR
 
Join Date: Nov 2010
Posts: 64
judicial85 is on a distinguished road
Default Num Lock ERROR

Hello all,



Upon installing the Add-In MATRIX 2.3 - Matrix and Linear Algebra functions for EXCEL from http://digilander.libero.it/foxes/SoftwareDownload.htm ...

every time Excel, or one of its files, is opened the Num Lock key shuts off. Took me a very long time to figure out the "random" off-ing of Num Lock, but disabling the add-in has it working properly again.

Can anybody suggest WHY this happens? Also, if there is a way to fix the code/add-in so it doesn't bother me when I open files?

Thanks for any insight here!

Bryan
Reply With Quote
  #2  
Old 11-30-2011, 01:03 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Num Lock ERROR Windows XP Num Lock ERROR Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Contact the add-in's author to take the matter up with him.
Reply With Quote
  #3  
Old 11-30-2011, 09:54 AM
judicial85 judicial85 is offline Num Lock ERROR Windows 7 Num Lock ERROR Office 2010 (Version 14.0)
Advanced Beginner
Num Lock ERROR
 
Join Date: Nov 2010
Posts: 64
judicial85 is on a distinguished road
Default

I have checked that site (Foxes Team), but they seemed to have shut down around 2006 - so if it is a compatibility issue between 2003 and 2007/2010 versions I don't know (except a different Add-In from there does not behave this way).

"Yes, dear friends, after more then 10 years, the activity on this site is closing.
This site will be still open for a while, as a sort of ancient miner, but none new software will be released."

Now, the xla document is not password protected, so if there is something I can manually search for that is also possible...
Reply With Quote
  #4  
Old 05-01-2012, 10:17 PM
Peter Wienand Peter Wienand is offline Num Lock ERROR Windows 7 64bit Num Lock ERROR Office 2010 32bit
Novice
 
Join Date: May 2012
Posts: 15
Peter Wienand is on a distinguished road
Default Fix for MATRIX Add-In

The cause of this problem is that multiple SendKeys are being called in quick succession.

http://support.microsoft.com/kb/179987

The MATRIX add-in only has one SendKeys statement, so it is actually the interaction between this add-in and some other add-in with SendKeys statement(s) that is causing the problem.

The following modification removes the SendKeys statement from the MATRIX add-in and might resolve this issue for you.

1. Open Excel and open the VBA editor (ALT-F11)

2. In the project explorer panel up the top left...
2. a. Expand VBAMatrix (matrix.xla)
2. b. Expand Modules folder under VBAMatrix
2. c. Double click on Initialize

3. Press CTRL-F and search for "SendKeys" (without the quotation marks!)

4. Replace the following line of code
Application.SendKeys "%^{F9}"
with
'Application.SendKeys "%^{F9}"
Application.CalculateFull
Reply With Quote
  #5  
Old 05-02-2012, 07:01 AM
judicial85 judicial85 is offline Num Lock ERROR Windows 7 Num Lock ERROR Office 2010 (Version 14.0)
Advanced Beginner
Num Lock ERROR
 
Join Date: Nov 2010
Posts: 64
judicial85 is on a distinguished road
Default

Interesting!! You for sure hit the nail on the head with that one. Hiding that particular statement removes the issue outright.

- I tried the "DoEvent" command above it as in the MS forum link, but that did nothing.
- I've replaced SendKey with the CalculateFull method

Any idea what the purpose of it was? Looked like %^{F9} was setting up a shortcut key or something... what does CalculateFull do instead? Seems like it puts the previous code into "context" for Excel..?

Thanks, Bryan
Reply With Quote
  #6  
Old 05-04-2012, 05:20 AM
Peter Wienand Peter Wienand is offline Num Lock ERROR Windows 7 64bit Num Lock ERROR Office 2010 32bit
Novice
 
Join Date: May 2012
Posts: 15
Peter Wienand is on a distinguished road
Default

The SendKeys statement sends keystrokes to the application - basically it is simulating a user pressing keys on the keyboard. In this case the string "%^{F9}" simulates the user pressing ALT-CTRL-F9. If you are interested, you can find more information about the SendKeys syntax here...

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

The ALT-CTRL-F9 shortcut causes the recalculation of all cells on all worksheets in all open workbooks. The CalculateFull statement tells Excel to do the same thing, so we can use it instead of the SendKeys statement without changing the behaviour of the macro.
Reply With Quote
  #7  
Old 05-04-2012, 10:43 AM
judicial85 judicial85 is offline Num Lock ERROR Windows 7 Num Lock ERROR Office 2010 (Version 14.0)
Advanced Beginner
Num Lock ERROR
 
Join Date: Nov 2010
Posts: 64
judicial85 is on a distinguished road
Default

Thanks Peter! That saves me some research time. Who knows? Maybe I can use that in future Macro-building..

Best,
Reply With Quote
Reply

Tags
add-ins, error, num lock

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Num Lock ERROR How do I lock in a Date in a cell? GatorFan1 Excel 2 12-02-2011 09:33 PM
Need To Lock Colors In Graphics bcicio PowerPoint 3 11-24-2010 07:47 AM
Lock a Slide Pemberton PowerPoint 0 07-18-2010 04:43 AM
I want to lock a sentence in Word smorkette Word 1 02-06-2010 12:57 AM
How Ms Word Lock memo85 Word 0 08-16-2009 07:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft