invisible formula in formula bar
 

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

invisible formula in formula bar
 

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.

Narendra Boga wrote:

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

--

Dave Peterson