Create an active X button that hides rows that have "0" qty values

I am a lighting designer for an event venue.

I have an excel document that is an equipment list I use to generate Request for Quotes to submit to vendors.

Essentially its a long list of every possible light, cable, power distro possible.

I fill in qtys, then manually hide rows that are not used for a specific list. Its really tedious and prone to user selection errors currently.

I have an example file here, with the button and the code I have been trying to use.

---

Private Sub CommandButton1_Click()

For a = 23 To 609

If Worksheets("Typical").Cells(a, 24).Value = "0" Then

Worksheets("Typical").Rows(a).Hidden = True

End If

Next

End Sub

---

This code is not working as I would like currently.

There are also row headers that I would also like the ability to hide with the same button if inactive. They have 0 values in the q column instead of the a column as a normal line item would.

Any help/advice greatly appreciated. I've used excel all my life, but basically only on a surface level.

I believe I have attached an example file.