| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect a worksheet such that cell value can be edited ?
How can I protect a worksheet in that way that the user is able to edit cell
values but is not allowed to make invisible columns visible again. In case that I protect a worksheet, the user is not able to make invisible columns visible again, however the user can't edit any cell also, which should be enabled though. Oscar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to protect a worksheet such that cell value can be edited ?
Oscar
unlock the cells where you want input and then protect the sheet with a password. Format | Cells... | Protection tab | Locked = false (not ticked) Regards Trevor "Oscar" wrote in message .nl... How can I protect a worksheet in that way that the user is able to edit cell values but is not allowed to make invisible columns visible again. In case that I protect a worksheet, the user is not able to make invisible columns visible again, however the user can't edit any cell also, which should be enabled though. Oscar |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to protect a worksheet such that cell value can be edited ?
Thanks Trevor,
this is what I needed. regards, Oscar "Trevor Shuttleworth" schreef in bericht ... Oscar unlock the cells where you want input and then protect the sheet with a password. Format | Cells... | Protection tab | Locked = false (not ticked) Regards Trevor "Oscar" wrote in message .nl... How can I protect a worksheet in that way that the user is able to edit cell values but is not allowed to make invisible columns visible again. In case that I protect a worksheet, the user is not able to make invisible columns visible again, however the user can't edit any cell also, which should be enabled though. Oscar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set a few columns on a worksheet which can be edited by ot | Excel Discussion (Misc queries) | |||
| Allow rows to be inserted and edited in a protected worksheet | Excel Worksheet Functions | |||
| Protect Cell from being edited | Excel Discussion (Misc queries) | |||
| update a date cell only when worksheet is edited | Excel Discussion (Misc queries) | |||
| How do I protect my comments from being edited by another user? | Excel Discussion (Misc queries) | |||
Linear Mode
