Log In
Register
Home
March 10, 2016
Offline
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!!
Trusted Members
February 13, 2021
Offline
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).
VIP
Trusted Members
December 7, 2016
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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
1 Guest(s)
