Password for cells and Password for sheet

  • Thread starter Thread starter Emece
  • Start date Start date
E

Emece

I have some cells protected with a password so that they cannot be modified,
and I want to add a different password to the sheet. Is this possible? Thanks
in advance.
Regards,
Emece.-
 
xl2002 (IIRC) added range protection.

If you're using xl2002+, you may want to look at that.

In xl2003 menus:
tools|Protection|Allow users to edit ranges
will get you close.
 
I am a little lost by your question. Cell protection is controlled by the
cell being either locked or unlocked. the lock itself does nothing until the
sheet is protected. Once the sheet is protected then only the unlocked cells
may be modified. Individual cells do not have passwords. The only password is
attached to the sheet.

If you want different users to have different accesses then look at
Allow Users to Edit Ranges...
on the protection menu.
 
Back
Top