Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Display Or Hide Cell Values. If A21 does not contain any value then the code displays all rows. Display hidden cell values.
How To Quickly Hide Cell Contents In Excel from www.extendoffice.com
The following Private Sub should work whether the cell value changes manually or as a result of a formula. I am trying to hide the display of the values the formulas with functions in the case of certain cells but it seems that you can only protect them from editing. You may require show or hide the formula for different situations.
If A21 does not contain any value then the code displays all rows.
In the Format Cells dialog box on the Number tab select the Custom formatting and then in the Type field type to hide any value in the cells. Similarly the formula is visible in the formula bar and if your Excel sheet is to be shared with teammates or publicly you may want to hide the hard-written formula in the formula bar. If you have a large worksheet you might want to hide some rows and columns for data you dont currently need to view. Always hiding a worksheet once a report has been run can be accomplished by using the keywords AUTOHIDEHIDESHEET in cell A1 of.
