Hi
Menu Format Cells Protection, check Locked and Hidden. Now protect the sheet with menu
Tools Protection Protect worksheet.
You won't be able to enter anything anywhere now -unless you in forehand has unchecked
Locken in the entry cells, same Format menu, before protecting. So do that too.
--
HTH. Best wishes Harald
Followup to newsgroup only please.
"dgmorr " wrote in message
...
Hello,
I have a problem. I have a series of cells which display calculated
averages. When the calculations are done, the value is displayed in
those cells. What I want to do is be able to hide the function when I
highlight the cell. Now, when I select the result cell, the function is
displayed in the text box at the top of the screen. How do I make is so
that the text box will display the result and not the formula, thanks.
---
Message posted from http://www.ExcelForum.com/