|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.

What about to add a section to your macro to unprotect your sheet, then run
normally your code and then protect it again?

have a good day

Tomasz