View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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