hide formulas

[Soz]

Who can help pls?
I know how to protect a worksheet but is there also a way
to hide the formulas so no one can see them?
Regards
Soz

 

[Guest]

In the Format/Cells dialog, there's a Protection Tab, and there's a checkbox
for hidden -- when the worksheet is then protected, all cells with this
checkbox on will not be viewable.

 

[dcronje]

Before you protect the worksheet select the cells that contain th
formulas you want to hide and then right click select properties and o
the protection tab check "hidden" and then protect the worksheet. Th
formulas should be hidden