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

On Thu, 16 Dec 2004 08:13:02 -0800, "Mike"
wrote:

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.