How to hide formulas in excel?

[jb]

hi experts,
I have a workbook in which one part of one excel sheet contains formulas.
I want to protect such cells so that it is not visible to users of that workbook.
Is there any way to do this?

 

[bobhc]

Good day jb

This link should help you


http://office.microsoft.com/en-gb/excel-help/display-or-hide-formulas-HP005199811.aspx


.

 

[jb]

hi bobhc,
i gone thru the link. but the formula can be unprotected easily.
so any other secure method?

 

[bobhc]

The short answer is no, the protection in excel is about as much use as an ashtray on a motorcycle.

 

[jb]

thanks sir