Protection for selected users
 

I have used the tools protection and set a password so that only certain
cells can be edited.

Can I overwrite this for certain users i.e. myself so that I don't have to
keep removing the password to do other work?

Thanks

Protection for selected users
 

If you're using xl2002+, you can allow certain users to edit certain ranges.
They'll (you!) will have to enter the password for that range at least once,
though.

You'll see these more granular protection options in that tools|Protect|protect
sheet dialog.

Funkyfido wrote:

I have used the tools protection and set a password so that only certain
cells can be edited.

Can I overwrite this for certain users i.e. myself so that I don't have to
keep removing the password to do other work?

Thanks

--

Dave Peterson

Protection for selected users
 

Oops.

You'll see this in the:
Tools|Protection|Allow users to edit ranges dialog



Funkyfido wrote:

I have used the tools protection and set a password so that only certain
cells can be edited.

Can I overwrite this for certain users i.e. myself so that I don't have to
keep removing the password to do other work?

Thanks

--

Dave Peterson