Excel: Use button to hide/unhide rows based on cell value. Change/toggle button name.

Question

After almost four hours of trying to cobble together my own solution (I obviously have failed), I'm turning to the community.

Scenario: a worksheet used to track cost-saving actions includes plan and actuals. The value in Column G is either "Plan" or "Actual". The first "Plan" row is Row 11 (and then every other row is a plan row). I'd like to enhance the worksheet where:

• the default view does not show the plan rows
• a button above Column G is named "Show Plan"
• when the user clicks the "Show Plan" button, the plan rows (11, 13, 15,...) appear AND the button name changes to "Hide Plan."
• -when the user clicks the "Hide Plan" button, the plan rows (11, 13, 15,...) are hidden AND the button name changes to "Show Plan."

Thanks for your guidance

Answer 1

Hi Steve,

Please share any updates at your convenience.

Thanks,

Frank