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