limit worksheet view to specified cell range

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.

--
George Nicholson

Remove 'Junk' from return address.


"Mike" <Mike@discussions.microsoft.com> wrote in message
news6557644-631F-43A0-9450-547E32AE4D18@microsoft.com...
> 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.

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" <Mike@discussions.microsoft.com>
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.