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.