Select the cells with the formulas, and do Format - Cells - Protection, and de-select
"Locked." Then protect the sheet -- Tools - Protection -- Protect Sheet.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"JBoyer" wrote in message
...
Is there a way you can place a lock on a cell to prevent removing or changing
a formula. If so how do you apply it and also take it off?