This video demonstrates how to lock or protect formulas in Microsoft Excel using a VBA macro. The solution will still allow input of values but will prevent formulas being deleted or changed. This is a great method for protecting a worksheet but still allowing user input.
------------------------