Forum Discussion

StijnCl's avatar
StijnCl
Copper Contributor
May 12, 2020
Solved

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...
excel
Excel on Mac
Formulas and Functions
bhushan_z's avatar
bhushan_z
Iron Contributor
May 12, 2020
I believe you will need VBA code for this.
StijnCl's avatar
StijnCl
Copper Contributor
May 12, 2020

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_z's avatar
    bhushan_z
    Iron Contributor
    May 12, 2020

    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.

    • StijnCl's avatar
      StijnCl
      Copper Contributor
      May 12, 2020

      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.

Resources