Hello People,
I have written some complex formulas which I dont want other people t
view.
However the results should get displayed in the same cells minus th
formulas.

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

Plzz help fast!!

Thanks in advance.....

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

Hi,

Use Format|Cells|Protection and check the 'hidden' option. For any cells you
want users to be able to edit, uncheck the 'locked' option. Then use
Tools|Protection|Protect, with your preferred password, to protect the
worksheet.

Cheers


"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/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004

Format Cells : Protection - Hidden
Tools Protection Protect Sheet

You might also want to use a password, but it's not necessary if you just
want to hide the formulas.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"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/

In the cell format menu, go to protection and tick the "hidden" chec
box. Next, protect the worksheet.

Dunca

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

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/