Restricting access to a range of cells
 

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

Restricting access to a range of cells
 

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

"anandmr65" wrote in
message ...

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