how to hide formulas
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
|