Protection for selected users

[Funkyfido]

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]

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.

 

[Dave Peterson]

Oops.

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