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

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

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