hiding formulas

Bill · Jul 11, 2003

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

Gord Dibben · Jul 11, 2003

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