A different approach would be to hide this sheet using xlSheetVeryHidden for
the visible property in the properties window for the sheet (accessible from
the control toolbox toolbar). Then in a sheet that the user will see,
reference the results of the formula

=SecretSheet!B9

You might want to hide the linking formula in this cell as well to decrease
curiosity (the others have told you how to do that). You can also hide the
formulas on the "SecretSheet" before hiding it (hide and protect the
sheet.)

Protect the structure of the workbook in Tools=Protect=workbook. so the
sheet can't be unhidden.

Just a caution that this level of password protection is pretty weak. Code
which will break these passwords is posted in these groups on a pretty
frequent basis.

--
Regards,
Tom Ogilvy

"anurag.d " wrote in message
...
Hello People,
I have written some complex formulas which I dont want other people to
view.
However the results should get displayed in the same cells minus the
formulas.

I think this is possible.But cant figure out how??

Plzz help fast!!

Thanks in advance......


---
Message posted from http://www.ExcelForum.com/