ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Scroll lock.... (https://www.excelbanter.com/excel-discussion-misc-queries/129122-scroll-lock.html)

Ximena

Scroll lock....
 
I need to turn my scrl lock key off, I have a wireless keyboard and I think
the "scrlk" key doesnt't work. Is there any other way I can turn it OFF?
Thanks

Dave Peterson

Scroll lock....
 
I think I'd get the manual out. Maybe there's a function button that has to be
held down while you toggle that key.

In fact, you may want to post the name/model of your wireless keyboard--maybe
someone hanging around here uses it.

Or search google for help.

But you can use a macro inside excel that can toggle that setting.

Option Explicit
Declare Function SetKeyboardState Lib "User32" _
(kbArray As Byte) As Long
Declare Function GetKeyboardState Lib "User32" _
(lpKeyState As Byte) As Long
Sub ToggleScrollLock()
Dim KeyState(0 To 255) As Byte
GetKeyboardState KeyState(0)
KeyState(&H91) = 0 ' = 0 for off, = 1 for on
SetKeyboardState KeyState(0)
End Sub


When I tested it, the keyboard light got out of sync with the actual
function--but the SCRL in the statusbar was correct.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ximena wrote:

I need to turn my scrl lock key off, I have a wireless keyboard and I think
the "scrlk" key doesnt't work. Is there any other way I can turn it OFF?
Thanks


--

Dave Peterson

Ximena

Scroll lock....
 
Make: Microsoft wireless 1.0A, Model: 1027
Thanks

"Ximena" wrote:

I need to turn my scrl lock key off, I have a wireless keyboard and I think
the "scrlk" key doesnt't work. Is there any other way I can turn it OFF?
Thanks



All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com