VBA Code Troubleshooting

Hi All,

I am trying to create VBA code that will automatically hide rows in my spreadsheet depending on whether other reference cells are marked with a Yes or a No.

You select what items are included in the list (Flask, Toolkit, Cage, and Box). If you select Yes, this item is included in the list in cells B8:E11. If you select No, I would like the entire row for that item to be automatically hidden.

Example:
Flask: Yes
Toolkit: No
Cage: Yes
Box: Yes

In the above situation, row 9 on this spreadsheet should be automatically hidden, since that is the dedicated line for toolkits. With the help of GPT, I am currently working with the following code:

SHEET1 (Code):

Please Login or Register  to view this content.

MODULE (Code):

Please Login or Register  to view this content.

So far, the macro works great, but I want this to happen automatically, which it currently does not. With the above code, selecting Yes or No changes nothing, unless I run the macro manually.

Also, I have used the Worksheet_Change function in a separate spreadsheet (also for automatically hiding rows) for a separate purpose, and it worked fine there, so I don't think that is the problem.

Anybody have any ideas as to how I can get this to work?