| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection for selected users
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protection for selected users
Oops.
You'll see this in the: Tools|Protection|Allow users to edit ranges 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sheet protection - only selected range to be able to select/input data | Excel Worksheet Functions | |||
| Allowing users to edit selected ranges only | Excel Discussion (Misc queries) | |||
| Disable Tools Protection Protect Sheet for all users but one | Excel Discussion (Misc queries) | |||
| Protection in Excel - how do i hide some info. from some users? | Excel Discussion (Misc queries) | |||
| Why aren't the exceptions I selected in WS Protection working? | Excel Worksheet Functions | |||
Hybrid Mode
