Thread: Hide Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Wiggins Andy Wiggins is offline
external usenet poster
 
Posts: 107
Default Hide Formulas

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/