Macro to expand and collapse rows based on criteria in cells

Hi jholiday78,

See the attached file which contains an updated copy of your workbook. The following code is used to do what you requested:

In an ordinary code module such as Module1:

Please Login or Register  to view this content.

Lewis

Hi Lewis,

It took me a bit to figure it out, but I understand what you did now. This is great.

I know I added buttons in there, but I was wondering is there a way to eliminate the button and have the action triggered by the text "Yes", or "No"? I understand it, but I can see my co-workers getting frustrated that they have to select from the drop down first and then click on a button to expand/collapse. Does that make sense?

is there a way to eliminate the button and have the action triggered by the text "Yes", or "No"?

My initial thought several days ago was that this is what you really needed, but didn't ask for. See the attached file which does NOT CHANGE the original code, but adds the code below (which is included in the new file).

The following code in the ThisWorkbook module makes sure the rows are expanded/collapsed per 'Yes/No' (case insensitive) in Column 'B' when the Workbook is OPENED.

Please Login or Register  to view this content.

The following code in the 'Sheet2' module expands/collapses rows per 'Yes/No' in Column 'B' each time there is a change in Column 'B'.
NOTE: The items in red below previously existed in the 'Sheet2' module and should ONLY exist ONCE in the module.

Please Login or Register  to view this content.

Lewis