hiding formulas

B

Bill

I want to be able to hide formulas from people that are
using the spreadsheet. When you click on a cell that has a
formula, I don't want it to be shown. Thanks
 
G

Gord Dibben

Bill

Select cell(s) with formula(s). Format>Cells>Protection check "hidden".

Tools>Protection>Protect Sheet.

Sheet must be protected to hide formulas with this method.

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Top