Combining Excel sheet protection and XLS Padlock protection

 

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

 


Copyright © 2021 G.D.G. Software