Forum Discussion
Protecting cell formatting but allowing edits to values
I am building an Excel tool for use by many people. I would like to protect the cell formatting while allowing the users to change the values of these same cells. Is this possible?
Yes thanks - this allows me to lock parts of a worksheet and allow editing to other parts, but I don't think this allows me to protect the formatting of the cells I want to allow the users to edit.HansVogelaar.
For example in the area where I want to allow the user to edit the cell (say change a 5 to a 6), I do not want the user to override my conditional formatting or data validation.
Users won't be able to modify conditional formatting and data validation directly, but they can overwrite it by copying/pasting from elsewhere.
It is difficult to prevent this; it's best to educate users not to use the standard Paste (or Ctrl+V) but to Paste Special as Values only.