Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn scroll lock off (2007 excel)? No scroll lock key
The keyboards we use don't have a scroll lock button and someone has somehow
accidentally turned the scroll lock on and the arrows now move the whole sheet instead of between cells. Can't seem to locate short cut or command to turn scroll lock off. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn scroll lock off (2007 excel)? No scroll lock key
Righ Click on worksheet (say sheet1), then click on View Code.
paste the below code 'Begaining of the code Private Declare Sub keybd_event Lib "user32.dll" _ (ByVal bVk As Byte, ByVal bScan As Byte, _ ByVal dwFlags As Long, ByVal dwExtraInfo As Long) Private Declare Sub Sleep Lib "kernel32" _ (ByVal dwMilliseconds As Long) Const VK_SCROLL = &H91 Const KEYEVENTF_KEYUP = &H2 Private Sub myScroll_Lock() keybd_event VK_SCROLL, 0, 0, 0 'Press Scroll Lock keybd_event VK_SCROLL, 0, KEYEVENTF_KEYUP, 0 'Release Scroll Lock End Sub 'end of the code now go back to your excel sheet and goto Macros (Alt+F8), and run myScroll_Lock everytime you run this function the scroll lock will toggle. -kc *Click YES if this works "Cameron A Perth" wrote: The keyboards we use don't have a scroll lock button and someone has somehow accidentally turned the scroll lock on and the arrows now move the whole sheet instead of between cells. Can't seem to locate short cut or command to turn scroll lock off. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scroll lock in Excel only | Excel Discussion (Misc queries) | |||
How to navigate with arrow keys in Excel 2007? Tried Scroll Lock! | Excel Discussion (Misc queries) | |||
how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
Scroll lock is stuck and won't turn off | Excel Worksheet Functions | |||
how to turn SCROLL LOCK OFF, when kwy not on keyboard? | Excel Discussion (Misc queries) |