Microsoft Excel - Range Hide Formula
Asked By John on 26-Mar-10 09:57 AM
I WOLD LIKE TO HIDE FORMULA IN A SELECTED RANGE,BUT RESULT SHOULD SHOW THERE. CAN WE USE SOME COMMAND ALONG WITH THE FORULA WHICH I USED IN A SPECIFIC AREA OR CAN WE USE MACRO TO HIDE FORMULA IN A SELECTED RANGE.
Jonathan VH replied to John on 26-Mar-10 11:05 AM
The only way I can think of would be to unlock all cells on the sheet, then lock the cell() with such formulas, and finally protect the sheet and uncheck the option to Select locked cells.