Restricting access to a range of cells

[anandmr65]

Hi,

I have a file in shared folder that will be used by about 4 or 5 people. Each one will be updating a particular range everyday.For eg. User A updates from A1 to A100, User B updates the range B1 to B100 and so on.

To prevent any problems, I want to restirct the user A to access only the range A1 to A100, and user B to access B1 to B100.

Can this be achieved in excel?

I though of locking the cells and giving the password, but all users will have only one password.

Please help.

Thanks & rEgards
Anand

[JON JON]

It depends on the version of xl you are using. I know xl2002 have this
feature.

"anandmr65" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I have a file in shared folder that will be used by about 4 or 5
> people. Each one will be updating a particular range everyday.For eg.
> User A updates from A1 to A100, User B updates the range B1 to B100 and
> so on.
>
> To prevent any problems, I want to restirct the user A to access only
> the range A1 to A100, and user B to access B1 to B100.
>
> Can this be achieved in excel?
>
> I though of locking the cells and giving the password, but all users
> will have only one password.
>
> Please help.
>
> Thanks & rEgards
> Anand
>
>
> --
> anandmr65
> ------------------------------------------------------------------------
> anandmr65's Profile:
> http://www.excelforum.com/member.php...o&userid=30728
> View this thread: http://www.excelforum.com/showthread...hreadid=565091
>