Password for cells and Password for sheet

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.-
 
D

Dave Peterson

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.
 
J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top