I want to protect sheet because I have some formulas that I don't want people
hace access to it to modify. But I have some cells that people will enter
some values and they give a message and change the cell color depends of the
value that they enter. My problem is when I protect the sheet using Tools
Protection Protect Sheet... and when I write the value that I want in the
cell when sheet is protected I have an error. I obtain the message that I
want but when the cell will change the color I received and error message
like: "Run-time eoor '1004': Unable to set the ColorIndex property of the
Interior class". How can I resolve that problem. When the sheet is
unprotected my code working great but when it protected I recived this
message.

Thanks in advance.