Forum Discussion
StijnCl
May 12, 2020Copper Contributor
Invisable Rows
Question How do I create (in)visible cells based on a value in a certain cell? Specifications In an Excel file I created I have a number of rows that only need to be visible when a certain quest...
- May 12, 2020
StijnCl Try the attached file.
Note: Macros are for fixed rows and cells. If you insert/delete rows, it might fail.
SergeiBaklan
May 12, 2020Diamond Contributor
VBA if you'd like to hide entire rows.
If to hide cells values in these rows you may apply conditional formatting rule applying white on white color for them (or like). However, they will be visible in formula bar if user focuses on such cell.
- StijnClMay 12, 2020Copper Contributor
Thank your for your answer SergeiBaklan !
Unfortunately I can't write a VBA-code that's why I have this question.