invisible formulae

  • Thread starter Thread starter Libby
  • Start date Start date
L

Libby

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.
 
Hi
'Format - Cells - Protection' and check the second checkbox
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

userform exception error 4 textboxes 7
Formula Bar Hidden 6
Insert Row also adds formulas and moves cursor 2
Mid column sum formulas with varied ranges to sum 17
Formula appearing as Value in Formula Bar 1
#value error 2
Why do charts disappear? 2
The easiest way to copy a sheet of formulas! (Excel 2007) 1

Back
Top