Mike Daniels
Board Regular
- Joined
- Feb 28, 2006
- Messages
- 73
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
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