Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming |