invisible formula in formula bar

N

Narendra Boga

hi..

can we hide the formula that is visible in formula bar?
I have created some formulas for shared excels. Can I hide the formula that
is looking in formula bar and the result only visible in cell.

plz help me..

thanks
Narendar Boga
 
D

Dave Peterson

In xl2003:
Format|cells|protection tab.
Check Locked and check Hidden.

Then protect the worksheet.
Tools|Protection|Protect sheet.

The workbook can't be shared when you change the worksheet protection.
 
Top