This may not help, but its worth trying:

1. Unprotect the worksheet
2. Unlock all cells in the worksheet
3. Lock only the specific cells containing formulae
4. Protect the worksheet
--
Gary's Student


"MFY" wrote:

I have a shared excel spreadsheet with filter and formulas, I need to lock or
protect the formula, but when I set protection on the filter column will not
work eventhough I have enable the column to be filtered. Please help.