hide formulas

S

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
 
B

Bob Umlas, Excel MVP

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.
 
D

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
 
Top