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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to hide formula 5
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Data visible in formula bar, but not in cells 1
Formula text in woorksheet cell 2
Configure Formula Bar 6
Formula bar 1
Excel Formula Issues 1
Hide a Formula 3

Top