I am working a project where I want to limit the user changes via either a
form or a macro. In other words I do not want the user to be able to alter a
cell's content directly.

I know I could hide the worksheet or columns but the user has to be able to
view their content without directly altering them.

I tried locking the cells and password protecting the worksheet but then
when I attempt to clear the cell content via macro I get an error message.
Is there way to set the cell property for protection or no protection? I have
searched help without much success.

Error message:

Run-time error '1004':
The cell or chart that you are trying to change is protected and
therefore read-only.

To modify a protected cell or chart, first remove protection using the
Unprotect Sheet command (Review tab, Changes group). You may be
prompted for a password

--
Kermit, long time windows Office user