MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disabel scrolling

Posted by Damien on July 03, 2001 7:52 PM

anyone know how to disable the scrolling function on a normal worksheet useing vb code don't want to be able to use the arrows keys or a intel mouse to move the screen from the current position anyone

Posted by Jim on July 03, 2001 8:31 PM

Try this code in the VBE "ThisWorkbook"
Private Sub Workbook_Open()
Worksheets("Sheet2").ScrollArea = "A1:J43"

Make the change to your sheet and your scrollarea