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
