I have a worksheet protected because it is all formulas for calculations with
other worksheets within the workbook. When I change one of the unprotected
cells of a worksheet, I want the formual cell to "update". It will if it is
not protected but the cell is locked and protected. How do I keep others
from editing the formula if I can not have the cell locked/protected?