Scroll Area Locking

[Mike Daniels]

Have tried several posted solutions but am unable to restrict scrolling to range F7:J17 of Sheet 1 (VISION RESULTS). Under Excel Object This Workbook the code entered was:
Sub Workbook_Open()
Application.Worksheets("Sheet1").ScrollArea = "F7:J17"
End Sub

In Module 1 I entered:
Private Sub Workbook_Open()
Worksheets("Sheet1").ScrollArea = "$F$7:$J$17"
End Sub

The only way I've fount to lock is modifying scroll area box of Sheet 1. But, it erases eah time the sheet is closed.

Can you help me find out what I am missing? Almost no VB knowledge.
Mike

 

[thuxley]

Hi Mike,

Not sure why you want to do this, but have you thought about freezing the panes at K18 and then protecting the worksheet or hiding the columns and rows you aren't using?

If I don't want people to go off to other parts of the worksheet, I hide the row and column headers too and protect cells and the worksheet, leaving only those cells unprotected that need their input or are of no consequence

 

[Mike Daniels]

Have just those areas of the sheet for user entry. The rest of the sheet displays different things based on the user input to the available cells. I did solve the problem with an "opening" macro that locks the scroll are and prevents them from going elsewhere. Don't know why I didn't think of that earlier... Thank you for your interest in my problem.

Mike