MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Don't show the data on the formula bar


Posted by rebecca on December 10, 2001 12:27 AM

Does anybody know how to made cell value to be hidden on the formula bar but can show in the active cell ?


Posted by Bruno on December 10, 2001 12:39 AM

Rebecca,
You can always hide the formula bar...

Posted by Ampleford on December 10, 2001 5:06 AM


::::::::::::::::::::::::::::::::::::::::::::::::::
Protect the cell, using "Format Cells", and also click on the HIDE button in the protect tab, then protect the spreadsheet.....