Want to hide formulas

[ankit bidawatka]

Dear all,

I have a spreadsheet where in two cells some formulas are written. i want to share that sheet with some one else but i do not want him to show formulas.

please help.

 

[SirJB7]

Hi, ankit bidawatka!


Check this:

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


For further reading about Excel security, which might be your next question, check this:

http://chandoo.org/forums/topic/macro-to-hideunhide-in-protected-sheet-produces-error-code#post-37901


Regards!

 

[ankit bidawatka]

Thanks......