Hi Baiju
I never try this put here is theory...
Excel allows you to hide formulas so that other users cannot simply
copy a worksheet and paste it into a new file (if they do, the results
of the formulae appear, not the formulas themselves). To set this
option you must first unprotect the worksheet:
Open the Tools menu, select Protection then Unprotect Sheet...
Click on cell C14 then open the Format menu and choose Cells...
Click on the Protection tab and then on Hidden to add a tick to the
check box - leave Locked set on as well - press <Enter or click on
[OK]
The formula isn't hidden yet (you can still see it on the formula bar)
but it will be once the sheet is protected:
Open the Tools menu, select Protection then Protect Sheet...
Press <Enter for [OK] without supplying a password or changing other
options
--
jetted
------------------------------------------------------------------------
jetted's Profile:
http://www.excelforum.com/member.php...o&userid=17532
View this thread:
http://www.excelforum.com/showthread...hreadid=561058