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

Damien,
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
HTH,
Jim