Thread: Hide Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
macropod[_6_] macropod[_6_] is offline
external usenet poster
 
Posts: 14
Default Hide Formulas

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