Limit users to a specific "viewning" range

  • Thread starter Thread starter Cliff
  • Start date Start date
C

Cliff

Hi all,

Is it possible to restrict the scrolling of a worksheet to a specific range. Just to keep noisy
people out of lists and other thing stashed in "distant" cells.

Thanks,

Jim
 
Nothing is foolproof in XL, security wise.
There's a work-around for just about every security measure, but you could
try this, and it might work for a couple of days<g>, if your users are not
well versed in XL.

Select the *entire* column past (to the right) of what you wish to be the
end of your sheet, and do:
<Ctrl> <Shift> <RightArrow>
This should take your selection to the last column (IV).
If it doesn't, repeat until it does.
Then, right click in this selection and choose "Hide".

Now, do the same thing with your rows, using the "DownArrow".

Protect your sheet with a password, and hope!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi all,

Is it possible to restrict the scrolling of a worksheet to a specific range.
Just to keep noisy
people out of lists and other thing stashed in "distant" cells.

Thanks,

Jim
 
You can limit the scrollarea in code. But it has to be reset each time you open
it. (xl doesn't remember this setting).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.ScrollArea = "a1:K99"
End With
End Sub

But be aware that if macros are disabled, then this code won't run.

And if the user knows a little bit, he can run similar code to change the
scrollarea to whatever he wants.

Excel's protection isn't really meant for this kind of security. I think that
it's really meant to protect the user from making data entry mistakes. (Locked
cells on a protected sheet for instance.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Dave said:
You can limit the scrollarea in code. But it has to be reset each time you open
it. (xl doesn't remember this setting).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.ScrollArea = "a1:K99"
End With
End Sub

But be aware that if macros are disabled, then this code won't run.

And if the user knows a little bit, he can run similar code to change the
scrollarea to whatever he wants.

Excel's protection isn't really meant for this kind of security. I think that
it's really meant to protect the user from making data entry mistakes. (Locked
cells on a protected sheet for instance.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Click to expand...
Thanks...not a problem I will just put the code in the Workbook_Open() event!

Jim
 
Back
Top