Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Tags
add-ins, error, num lock



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 04:11 PM.


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