limit worksheet view to specified cell range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a form with excel and would like users to view a specified cell
range. I know how to protect cells. The form is A1-F94 and I would like users
to only see that range of cells.
 
If using VBA you can use the ScrollArea property. As I recall, this setting
is not persistent (i.e., it doesn't save with the workbook) so it needs to
be set in the WorkbookOpen event or something similar.
 
Mike

Hiding the unused rows and columns then protecting the sheet is one method.

Setting the scrollarea using VBA is another method.

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:F94"
End Sub

Gord Dibben Excel MVP
 
Back
Top