XLS Padlock protection also works with Excel sheet protection (hidden or locked cells). In that situation, protected cells will not display anything in the Formula Bar. Generic PLEvalForm(N) / PLEvalFormD(N) function calls are not visible.



Note that protected formulas that have dependencies will fail if the dependencies are hidden. Avoid the Excel’s hidden attribute in this case.



Disable Formula protection