Protection of a cell
Posted by Charlotte Converse on February 05, 2001 4:59 PM
We have an excel spreadsheet that is protected. However in one cell we have a calculated field which is the result of quantity times price. If an individual goes to the = line and sees the formula they can remove it or if they simply hit delete in the cell, it deletes the formula. We would like to protect the formula so that cannot be changed at all by anyone but the creator. How can we do that?