how do you hide formulas that you don't want people to know

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)

"KEASTY" wrote in message
ps.com...
how do you hide formulas that you don't want people to know

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

"KEASTY" wrote:

how do you hide formulas that you don't want people to know

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)

"Bob Phillips" wrote in message
...
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)

"KEASTY" wrote in message
ps.com...
how do you hide formulas that you don't want people to know