Is there any way to limit the range a user may scroll / select in a worksht?

TIA

Ben

The vba help files are your friend

ScrollArea Property
See Also Applies To Example Specifics
Returns or sets the range where scrolling is allowed, as an A1-style range
reference. Cells outside the scroll area cannot be selected. Read/write
String.

Remarks
Set this property to the empty string ("") to enable cell selection for the
entire sheet.

Example
This example sets the scroll area for worksheet one.

Worksheets(1).ScrollArea = "a1:f10"
--
Don Guillett
SalesAid Software

"Benjamin" wrote in message
...
Is there any way to limit the range a user may scroll / select in a
worksht?

TIA

Ben

Thanks Don

"Don Guillett" wrote:

The vba help files are your friend

ScrollArea Property
See Also Applies To Example Specifics
Returns or sets the range where scrolling is allowed, as an A1-style range
reference. Cells outside the scroll area cannot be selected. Read/write
String.

Remarks
Set this property to the empty string ("") to enable cell selection for the
entire sheet.

Example
This example sets the scroll area for worksheet one.

Worksheets(1).ScrollArea = "a1:f10"
--
Don Guillett
SalesAid Software

"Benjamin" wrote in message
...
Is there any way to limit the range a user may scroll / select in a
worksht?

TIA

Ben

glad to help

--
Don Guillett
SalesAid Software

"Benjamin" wrote in message
...
Thanks Don

"Don Guillett" wrote:

The vba help files are your friend

ScrollArea Property
See Also Applies To Example Specifics
Returns or sets the range where scrolling is allowed, as an A1-style
range
reference. Cells outside the scroll area cannot be selected. Read/write
String.

Remarks
Set this property to the empty string ("") to enable cell selection for
the
entire sheet.

Example
This example sets the scroll area for worksheet one.

Worksheets(1).ScrollArea = "a1:f10"
--
Don Guillett
SalesAid Software

"Benjamin" wrote in message
...
Is there any way to limit the range a user may scroll / select in a
worksht?

TIA

Ben