Restricting access to a range of cells

[anandmr65]

Hi,

I have a file in shared folder that will be used by about 4 or
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 an
so on.

To prevent any problems, I want to restirct the user A to access onl
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 user
will have only one password.

Please help.

Thanks & rEgards
Anan

 

[JON JON]

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