Hide text in formula bar

B

Billy Thomas

I am using excel 97. I know it is possible to hide the edit or formula bar,
but I wan tit visible, just want the cell contents not to show up in it. I
konw that "hidden" option will work, but I don't want to protect the cells.
Is there anyway to have some cells not show up in the edit bar without using
protection?

thanks,

Billy
 
E

Earl Kiosterud

Billy,

If it's formulas you don't want shown, you can format the cells (Format -
Cells - Protection - Hidden). Then protect the worksheet (Tools,
Protection, Protect Sheet. If that isn't it, explain why you want a formula
bar, but don't want it to work sometimes.
 
Top