Automatically Hide/Unhide ROWS based on COLUMN Value

[scottrperry]

In Columns A and B I have created formulas that yield values I will use to hide Rows, such as "hide" and "autohide".
(I have a macro that hides all the rows where "hide" appears in Column B, works fine.)
I need a VBA to hide all Rows wherever Column A changes to "autohide", and unhide them when Column A changes to something other than "autohide".
I'd like to be able to reference named ranges instead of hard coding ranges in the VBA, but that's not a deal breaker.
Any help is appreciated.
(Excel/Office 365)

 

[Fluff]

What type of buttons are you using ActiveX or form controls?

 

[scottrperry]

currently I use Form Control whenever I need a button. (Mostly out of ignorance as to any advantage one has over the other.)

Ultimately, I'd like to have it "toggle" the state of the rows from hidden to visible, but just getting them to hide the way I want is my priority right now.

 

[Fluff]

In that case you assign your code to each button & use

Set rCheck = Range(ActiveSheet.Shapes(Application.Caller).TopLeftCell.Value)

Just ensure that the top left corner of the button is in the cell with the range name.

 

[scottrperry]

THANKS!
I get it. That will probably solve my issue.

 

[Fluff]

You're welcome & thanks for the feedback.