scroll lock

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
donaldb@281.com
"Benjamin" <Benjamin@discussions.microsoft.com> wrote in message
news:AF4CA8F1-BCAE-4072-9D96-843513A860D2@microsoft.com...
> 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
> donaldb@281.com
> "Benjamin" <Benjamin@discussions.microsoft.com> wrote in message
> news:AF4CA8F1-BCAE-4072-9D96-843513A860D2@microsoft.com...
> > 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
donaldb@281.com
"Benjamin" <Benjamin@discussions.microsoft.com> wrote in message
news:6280CB10-32D0-4288-A286-AF1F5F79AC8F@microsoft.com...
> 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
> > donaldb@281.com
> > "Benjamin" <Benjamin@discussions.microsoft.com> wrote in message
> > news:AF4CA8F1-BCAE-4072-9D96-843513A860D2@microsoft.com...
> > > Is there any way to limit the range a user may scroll / select in a
> > worksht?
> > >
> > > TIA
> > >
> > > Ben
> >
> >
> >