how to turn SCROLL LOCK OFF, when kwy not on keyboard?

G

Gord Dibben

Read the manual that came with your keyboard.

Or maybe you just missed seeing the ScrLk on the Pause/Break key?


Gord Dibben MS Excel MVP
 
C

Chip Pearson

Margarita,

You can use code like the following. Below are procedures for turning Scroll
Lock on, off, and toggling between on and off. It applies only to the
calling thread. It is not a system global method.

Public Declare Function GetKeyboardState Lib "user32" (pbKeyState As Byte)
As Long
Public Declare Function SetKeyboardState Lib "user32" (lppbKeyState As Byte)
As Long

Sub SetScrollLock()
Dim K(0 To 255) As Byte
GetKeyboardState K(0)
K(145) = 1
SetKeyboardState K(0)
End Sub

Sub ClearScrollLock()
Dim K(0 To 255) As Byte
GetKeyboardState K(0)
K(145) = 0
SetKeyboardState K(0)
End Sub

Sub ToggleScrollLock()
Dim K(0 To 255) As Byte
GetKeyboardState K(0)
If K(145) <> 0 Then
K(145) = 0
Else
K(145) = 1
End If
SetKeyboardState K(0)
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
T

Tyro

Gord:
You anwer a lot of questions; I have one concerning worksheet consolidation
using Excel's consolidation. Not my own.
No one will answer. Would you look at it for me, please?
 
G

Gord Dibben

Not a feature I have ever used but post the message ID do'd we can all have a
look at your question.


Gord
 
T

Tyro

I have posted. No one will answer

Gord Dibben said:
Not a feature I have ever used but post the message ID do'd we can all
have a
look at your question.


Gord
 
G

Gord Dibben

If you don't post the message ID I'm not inclined to go searching for your
original post.


Gord
 
C

Chip Pearson

I have posted. No one will answer

I answered.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
M

Margarita

To all the other answers: Key not on keyboard. I want to know how to turn
it On or Off from within the program's system.

Chip, somehow I think that you make more sense, but can you be a bit less
technical and more explicit?

Isn't dangerous to try and change the Reigester I.D. functions? (if it is
what this is)

Does "It is not a system global method." means that it will only work on
that one worksheet?

If that is the case, isn't too much work to be doing it for every worksheet?

Isn't there a much simpler answer, like for example a check mark in excel
options? he he... they should have thought about this one, either keyboard
makers or MSN programmers.
 
M

Margarita

the scroll lock function can be triggered in the On-Screen Keyboard. This
application is normally found in Start -> Programs -> Accessories ->
Accessibility
Clicking on the 'scroll lock' in the On-Screen Keyboard should have the same
function as pressing a physical scroll lock key.

This is much easier.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top