View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
have you protected the sheet? (Tools - Protection')

--
Regards
Frank Kabel
Frankfurt, Germany

Mald wrote:
There needs to be better protection on locked cells.

It is possible to alter the formatting of a locked cell by pasting
into the cell. Example pasting an entry copied from a % format into
a currancy format changes the cell to %. This also follows with
coulours etc.

Secondly a formula in a locked cell can be corrupted by inadvertantly
removing cells that it refers to and then replacing them.

Mald