How to protect a worksheet such that cell value can be edited ?

  • Thread starter Thread starter Oscar
  • Start date Start date
O

Oscar

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
 
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
 
You must log in or register to reply here.

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

Protect a worksheet but allow cell editing 3
Editing a Chart on a protected worksheet 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Controlling worksheet protection via VBA 0
How to make a worksheet Non-Editable even if extension is changed 1
file path or IP address protected 1
Allow VBA code to change a locked cell?? 2
Worksheet Protection 1

Back
Top