How do you set the Scroll Area on a worksheet so that the ability to move
around the sheet is limited to the selected area?
How do you set the Scroll Area on a worksheet so that the ability to move
around the sheet is limited to the selected area?
Hide all other rows and/or columns.
************
Anne Troy
www.OfficeArticles.com
"Paul Dusterhoft" <[email protected]> wrote in message
news:[email protected]...
> How do you set the Scroll Area on a worksheet so that the ability to move
> around the sheet is limited to the selected area?
>
Paul
Hiding the unused rows and columns then protecting the sheet is the usual
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:P60"
End Sub
Gord Dibben Excel MVP
On Tue, 20 Sep 2005 20:17:47 GMT, "Paul Dusterhoft" <[email protected]>
wrote:
>How do you set the Scroll Area on a worksheet so that the ability to move
>around the sheet is limited to the selected area?
>
You can also
Right-Click on your sheet-tab
Select View Code
If Properties Window is not shown press F4
In Properties Window, near bottom you'll see
Scroll Area - In blank box to right
enter desired Range, say B2:G20
Exit out of VBE
Done
"Paul Dusterhoft" <[email protected]> wrote in message
news:[email protected]...
> How do you set the Scroll Area on a worksheet so that the ability to move
> around the sheet is limited to the selected area?
>
Good tip Jim but this method is also lost when you close the workbook.
Has to be reset when re-opened, hence my Workbook_Open code.
Gord
On Tue, 20 Sep 2005 19:06:14 -0400, "Jim May" <[email protected]> wrote:
>You can also
>Right-Click on your sheet-tab
>Select View Code
>If Properties Window is not shown press F4
>In Properties Window, near bottom you'll see
>Scroll Area - In blank box to right
>enter desired Range, say B2:G20
>Exit out of VBE
>Done
>
>
>
>
>"Paul Dusterhoft" <[email protected]> wrote in message
>news:[email protected]...
>> How do you set the Scroll Area on a worksheet so that the ability to move
>> around the sheet is limited to the selected area?
>>
>
Wasn't aware of this feature (?). LOL
Thanks,
Jim
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]...
> Good tip Jim but this method is also lost when you close the workbook.
>
> Has to be reset when re-opened, hence my Workbook_Open code.
>
>
> Gord
>
> On Tue, 20 Sep 2005 19:06:14 -0400, "Jim May" <[email protected]> wrote:
>
>>You can also
>>Right-Click on your sheet-tab
>>Select View Code
>>If Properties Window is not shown press F4
>>In Properties Window, near bottom you'll see
>>Scroll Area - In blank box to right
>>enter desired Range, say B2:G20
>>Exit out of VBE
>>Done
>>
>>
>>
>>
>>"Paul Dusterhoft" <[email protected]> wrote in message
>>news:[email protected]...
>>> How do you set the Scroll Area on a worksheet so that the ability to
>>> move
>>> around the sheet is limited to the selected area?
>>>
>>
>
Hi Paul
Right click on the worksheet Tab and choose View Code.
If the Properties window is not visible, press F4.
In Scroll Area, set the range of the area you require.
Regards
Roger Govier
Paul Dusterhoft wrote:
> How do you set the Scroll Area on a worksheet so that the ability to move
> around the sheet is limited to the selected area?
>
>
But even after saving the Workbook;
Your Scroll Area is Lost;
See Gord's reply to my suggestion above..
Jim
"Roger Govier" <[email protected]> wrote in message
news:[email protected]...
> Hi Paul
>
> Right click on the worksheet Tab and choose View Code.
> If the Properties window is not visible, press F4.
> In Scroll Area, set the range of the area you require.
>
> Regards
>
> Roger Govier
>
>
> Paul Dusterhoft wrote:
>> How do you set the Scroll Area on a worksheet so that the ability to
>> move around the sheet is limited to the selected area?
Hi Jim
Thanks for the heads up!
I had not seen either your, or Gordon's post on my system when I posted my
response. I equally was unaware that the setting didn't "stick" on saving.
In all cases where I use the technique to prevent users accessing parts of
the sheet, I set it via code in the workbook open event, but thought that a
manual setting would also work and be a simpler answer for the OP.
Thank goodness we never stop learning!!!
Regards
Roger Govier
Jim May wrote:
> But even after saving the Workbook;
> Your Scroll Area is Lost;
> See Gord's reply to my suggestion above..
> Jim
>
> "Roger Govier" <[email protected]> wrote in message
> news:[email protected]...
>
>>Hi Paul
>>
>>Right click on the worksheet Tab and choose View Code.
>>If the Properties window is not visible, press F4.
>>In Scroll Area, set the range of the area you require.
>>
>>Regards
>>
>>Roger Govier
>>
>>
>>Paul Dusterhoft wrote:
>>
>>>How do you set the Scroll Area on a worksheet so that the ability to
>>>move around the sheet is limited to the selected area?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks