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?

Cells are "Locked" by default, but this only becomes active when you
protect the worksheet. If you want Users to be able to type values
into some cells but have others with formulae in protected, then first
of all you should unlock the cells for data entry. To do this, select
the cell(s) then click on Format | Cells | Protection Tab, then un-
check the Locked option and click OK. (I usually give those cells a
bright yellow background, to indicate to Users that they can enter
data there).

Then click on Tools | Protection then Protect Sheet. Here you have
further options (depending on the version of Excel you are using), and
you can decide to apply a password to the settings - if you enter a
password then you must re-enter it to confirm.

To unprotect the sheet, click on Tools | Protection and now you will
see an option to Unprotect Sheet. If you applied a password then you
need to enter it here, so choose one that you can easily remember.

You should note that Excel's security is not very firm, and can easily
be broken, but these steps can deter most users from trying to undo
your settings.

Hope this helps.

Pete

On Jul 5, 10:55*pm, JBoyer wrote:
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?

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?