I have a file with functions
I want to restrict the user and lock all the cells where the function is written
I know how to do that.
The question is how to lock the cells - so that the user will not see the function in the formula bar ???
Thank You!!
Short of hiding the function bar, it isn't possible. But once it's locked they can't make any changes to the function (unless they crack the security).
Hello,
While you are in the protect sheet/workbook window, you can untick the option to select locked cells. If they can't select such cell, it does not show any formulas either.
Br,
Anders
Hi Lea
Select the entire sheet.
Right-click any cell.
Select Format Cells - Protection and tick Hidden
Protect the sheet.
All formulas in the protected sheet will not be visible in the formula bar.
Hope this helps.
Sunny