Forum Discussion
Invisable Rows
- May 12, 2020
StijnCl Try the attached file.
Note: Macros are for fixed rows and cells. If you insert/delete rows, it might fail.
Thank you for your response bhushan_z !
I'm wondering which VBA-Code I need. I know how I find the VBA-code but I would like to know how I should write this code.
- bhushan_zMay 12, 2020Iron Contributor
StijnCl you will need a macro that runs every time a cell value changes (event-driven macro)
you can google it
Also, if you want me to build the code,
is it possible for you to share the file?
You may remove confidential info from the file.- StijnClMay 12, 2020Copper Contributor
bhushan_z I tried to implement the results I found on Google, but I it didn't work...
I attached the file in this comment. It's about the last two sheets. The cell that contains the question with the Yes / No answer is dark blue. I made the rows that need to vanish light blue.