invisible formulae
 

Hi All,

Theres a spreadsheet at work (by an author long since gone)
which has lots of formulae in.

When the sheet is protected the formulae are not shown in
the formula bar, and only appear if you unprotect the
sheet.

How is this done? When I tried it in a new workbook the
formulae were still visible, even though they couldn't be
edited.

invisible formulae
 

Hi
'Format - Cells - Protection' and check the second checkbox

--
Regards
Frank Kabel
Frankfurt, Germany


Libby wrote:
Hi All,

Theres a spreadsheet at work (by an author long since gone)
which has lots of formulae in.

When the sheet is protected the formulae are not shown in
the formula bar, and only appear if you unprotect the
sheet.

How is this done? When I tried it in a new workbook the
formulae were still visible, even though they couldn't be
edited.