Prevent the user from Edition / Erase / Format
 

Hello,

In the Excel sheet, I have several cells which are unprotected to allow the
user entering some information.
Tools / Protection / Protect the sheet : Cell Format is uncheck.
So the user is not able to change the format (color...) of the cell, BUT
he/she is able to *erase* the format !!! So after that the cell
is....protected !
How can we really protect (with VBA ?) the format of a cell which has to
remain accessible to the user typing.?
Thanks

Gérard