Non standard protection requirement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marsh - 19 Jan 2007 21:40 GMT

If I have three people who share a worksheet, can I implement worksheet
protection so the Person 1 can only edit cells in range1, Person 2 can edit
in range2 only, and likewise Person 3 only has rights to edit cells in range3.
This will be most useful to me if it can be done. If it can not be
accomplished, letting me know will be useful.
Many thanks
Marsh

Reply to this Message

Gord Dibben - 20 Jan 2007 00:25 GMT

Tools>Protection>Allow users to edit ranges may do what you want.

Gord Dibben MS Excel MVP

>If I have three people who share a worksheet, can I implement worksheet
>protection so the Person 1 can only edit cells in range1, Person 2 can edit
[quoted text clipped - 3 lines]
>Many thanks
>Marsh

Reply to this Message

Marsh - 20 Jan 2007 14:25 GMT

That did it. Thanks

> Tools>Protection>Allow users to edit ranges may do what you want.
>
[quoted text clipped - 7 lines]
> >Many thanks
> >Marsh

Reply to this Message