Hi All, I am trying to find a macro that I can assign to a shape labeled "Hide/Show Rows" (meant to be a button the user can click on that I will assign the macro to) in codename "sheet9" that:
- Hides all rows in most sheets except for 3 of them (please use codenames) based on the word "HIDE" in column A in each sheet
- If the user clicks the shape again I want it to fully open all rows in those sheets regardless of what is in column A