View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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