EXCEL VBA - Limit cell access (ScrollArea)

[bgreen]

Hi,

I am trying to limit user access to certain field ranges. I tried ScrollArea but that only works for one area. Is there a way to limt cell access for more then one range?

i.e. Only able to access and enter data in,
Range 1 = B1 and B2
Range 2 = A6 to C30

 

[SkipVought]

Hi,


Limit what?

Selecting cells?

Viewing cells?

Try UNLOCKING the desired cells and then PROTECT the sheet.

Skip,

_[red][/red]

 

[bgreen]

I want to make these stated cells the only cells the user can scroll to, and alter (enter, delete,etc... data)

 

[SkipVought]

Try UNLOCKING the desired cells and then PROTECT the sheet.


Skip,

_[red][/red]