how to hide formulas

  • Thread starter Thread starter KEASTY
  • Start date Start date
Lock the cell and protect the sheet. It is a simple cover, and is still
discoverable,

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi,

You can use the hidden property of the cell.

Slect all the cells you don't want people to see and then:-

Format|Cells|Protection and check the hidden (and locked if you want but
this is selected by default) property
Now select any cells you want user to edit and repeat the above but this
time remove the 'Locked' checkmark.

Apply a password to the sheet and your done.

Note this is not secure so it's not the answer if you want security.

Mike
 
Sorry, I meant hidden as Mike has said.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top