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