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

Contact the add-in's author to take the matter up with him.

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...

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

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

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.

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

Best,