Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password for cells and Password for sheet
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.- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password for cells and Password for sheet
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. Emece wrote: 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.- -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password for cells and Password for sheet
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. -- HTH... Jim Thomlinson "Emece" wrote: 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.- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password on a sheet | Excel Discussion (Misc queries) | |||
Password Protect a Sheet | Excel Discussion (Misc queries) | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
password protected Sheet | Excel Discussion (Misc queries) |