scroll lock
 

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

TIA

Ben

scroll lock
 

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

scroll lock
 

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

scroll lock
 

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