scroll area

[spiderman]

can i limit the scoll area on a page? (ie i want to have a data table that people can't get to on the same page)

 

[Mark W.]

Why don't you move the data table to a separate worksheet?

 

[lenze]

Just hide the rows or columns where the data table is located. If you then protect the Workbook with a password, users will not be able to view the the data table.

 

[Ian Mac]

On 2002-04-26 09:38, spiderman wrote:
can i limit the scoll area on a page? (ie i want to have a data table that people can't get to on the same page)

If your using XL97 this won't work.

If you right-click on the worksheet tab and select view code, in the properties of the Visual Basic Editor for that sheet there is a blank field called Scroll Area.

I say it does work for XL97 because you can select a area and I'll seem fine but save and close, the next time It'll be back to normal.

Having said that I just tried using

Private Sub Workbook_Open()

Sheet1.ScrollArea = "A1:M10"

End Sub

and that'll do it for you. change the range to suit.

 

[Robb__]

Spiderman

You could use the ScrollArea property of the worksheet. If you put this in, say the Activate event for the worksheet, it will limit the area to which the user can scroll.

Try this in Sheet1:
- Right click the sheet tab
- Code page appears
- Cut and paste this into the code page

Private Sub Worksheet_Activate()
Worksheets("Sheet1").ScrollArea = "A1:P40"
End Sub

- Return to the worksheets
- Select another worksheets then select sheet1

You should now not be able to scroll outside the given area.

Any help?

Regards

Robb__

 

[spiderman]

Thanks guys. works great.

 

[Mark W.]

On 2002-04-26 10:54, spiderman wrote:
Thanks guys. works great.

A word of caution... just because you can't scroll to something doesn't mean "[you] can't get to [it]".

 

[excelmacro]

I tried this with my sheet named Information Systems, and it works great...until I close the file and reopen it, at which point I can scroll where ever I want to

 

[Ivan F Moala]

On 2002-04-26 14:17, excelmacro wrote:
I tried this with my sheet named Information Systems, and it works great...until I close the file and reopen it, at which point I can scroll where ever I want to

The scrollArea is one of those settings
that do not remain once the workbook is closed......you will have to use Robs_ code
to reset it.