Page 1 of 1
Number Lock On/OFF Issue
Posted: Mon Sep 19, 2011 1:15 pm
by SRadabaugh
Using Excel 2007 with TM1. This is not really an issue but more like an annoyance. When ever Excel is opened the Num Lock is turned OFF. Is there an option or setting somewhere that would allow me to change this behavior?
Re: Number Lock On/OFF Issue
Posted: Mon Sep 19, 2011 1:40 pm
by qml
I've heard about this buggy behaviour of Excel 2007 before, but it was related to using SendKeys in VBA. Do you have any macros executed on workbook/application open that could be responsible for this?
Re: Number Lock On/OFF Issue
Posted: Tue Jun 12, 2012 1:21 pm
by tulips82
Has anyone been able to solve this? I have users on microsoft excel 2010 and tm1 9.5.2. Everytime they use perspectives numlock turns off.
Re: Number Lock On/OFF Issue
Posted: Tue Jun 12, 2012 8:18 pm
by moby91
As you are using Excel 2007, what happens when you disable the TM1 Ribbon Bar as outlined by some IBM Technotes ?
http://www-304.ibm.com/support/docview. ... wg21413700
Excel hangs or crashes with exception error message after upgrading to TM1 9.4 or higher
http://www-304.ibm.com/support/docview. ... wg21459558
Excel 2007 slowing down when TM1 Perspectives is active and connected
http://www-304.ibm.com/support/docview. ... wg21506333
Unable to print an Active Form from Perspectives: Blank/missing VB error
Re: Number Lock On/OFF Issue
Posted: Wed Jun 13, 2012 4:12 am
by Oratia623
This issue is only apparent when using TM1 with a keyboard with a number pad (ie not a laptop keyboard)
One way that I have used to get around this was to use the following VBA code.
This checks if the Numlock button is off, and turns it back on if needed.
(Usual caveats of use at your own risk etc)
Code: Select all
Private Declare Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) As Long
Private Const NumlockKey = 144
Private Sub Workbook_Open()
If GetKeyState(NumlockKey) = 0 Then
SendKeys "{NUMLOCK}"
End If
End Sub
In the case I was using it, I placed this code in a Workbook_Open macro in an Excel Add-in and placed this in the users XL start directory.
As it was as Add-in, it bypassed the need to enable the VBA code.
As it was in the Start Directory and in the Workbook_Open macro, it ran every time Excel opened.
I sucessfully tested this on Windows 7 with Excel 2007 & Excel 2010, however when running Win XP running Excel 2007 the SendKeys“{NUMLOCK}” didn’t do anything.
I never found an XP alternative as I didn't need to.
Re: Number Lock On/OFF Issue
Posted: Thu Jan 24, 2013 7:32 pm
by jameswebber
I am also having this issue, although the code works, the CXL ribbon finishes loading after my vba workbook open code.
Is there anyway to know when the ribbon has finished loading to invoke this.
Also be careful with windows UAC.
I found it is better to wrap the send keys function
so instead of this
This may work better
Code: Select all
CreateObject("WScript.Shell").SendKeys "{NUMLOCK}", True
Re: Number Lock On/OFF Issue
Posted: Tue Sep 10, 2013 3:05 pm
by sleepyEDB
Hello,
I too am experiencing this annoyance after a recent upgrade to Windows 7. I am fine with the official IBM solution of disabling the TM1 ribbon as the only function I need is the Explorer button. Does anyone know if there's another way to access the Explorer button other than on the ribbon itself?
*** EDIT ***
Nevermind, I found a workaround just after making my post. There is a TM1 entry in my Add-Ins menu at the top of Excel which wasn't present until the tm1pRibbonX.xlam file has been renamed. It certainly isn't as pretty as the TM1 ribbon, but it works for me and prevents the Num Lock from turning off.
Thanks,
sleepy
Re: Number Lock On/OFF Issue
Posted: Tue Sep 10, 2013 3:25 pm
by qml
In
this thread there is a good tip from Chris K.
Re: Number Lock On/OFF Issue
Posted: Tue Sep 10, 2013 3:26 pm
by skinners666
This issue has been addressed in TM1 9.5.2 FP3 and TM1 10.1.1 FP1.
http://www-01.ibm.com/support/docview.w ... wg1PM26333
Re: Number Lock On/OFF Issue
Posted: Tue Sep 10, 2013 4:33 pm
by sleepyEDB
Thank you both for the replies! I'll contact our TM1 server admin and notify them of FP1.
sleepy
Re: Number Lock On/OFF Issue
Posted: Mon Dec 09, 2013 8:25 pm
by Martin Ryan
Has anyone else experienced the issue after upgrading to 10.1.1 FP1? We've upgraded and we're still having problems. Using Excel 2010 over Citrix.
Martin
Re: Number Lock On/OFF Issue
Posted: Mon Dec 09, 2013 10:27 pm
by Wim Gielis
Martin Ryan wrote:
Has anyone else experienced the issue after upgrading to 10.1.1 FP1? We've upgraded and we're still having problems. Using Excel 2010 over Citrix.
Martin
Sure, it's still there. Very annoying.
Re: Number Lock On/OFF Issue
Posted: Tue Dec 10, 2013 9:18 am
by lotsaram
Still there in CX 10.1
Drives all the Controllers crazy.
Re: Number Lock On/OFF Issue
Posted: Fri Dec 13, 2013 12:30 am
by Martin Ryan
How annoying. It's a minor thing but it's one that really winds people up.
Re: Number Lock On/OFF Issue
Posted: Tue Feb 02, 2016 4:34 pm
by PDAZ
We've had the issue arise when we installed Office 2013. Has anyone found a solution other than disabling the toolbar?