Need help with code that isn't working as intended

With the help of GPT (and you guys), I wrote some VBA code that will automatically hide rows in another sheet depending on whether the answer is "Yes" or "No" in my current sheet.

My "Input Fields" tab has a list of parts. I can either select "Yes" or "No" for each part.

The "Commercial Invoice" sheet lists every single part by default, but if I select "No" to one of the parts in my "Input Fields" tab, I want the row in my "Commercial Invoice" tab to be completely hidden, automatically.

The macro for the HideRows() sub works perfectly fine when I run it manually, but the Module code does not, since the rows aren't being hidden automatically. The rows will only hide if I run the macro, but I want it to happen seamlessly. Here's the module code I am using:

Please Login or Register  to view this content.

Can you guys see any glooming issues with this code? I've no idea why I can't get it to work.

Originally Posted by TMS

If you want it to execute automatically, you'd need to use a Worksheet Change Event handler.

So I did initially have the subroutine named that "Worksheet_Change", but I already have another one of those set up for a different task.

How would I go about adding a second, or adding this into my code? I already have some code that changes things automatically in my workbook that works swimmingly, so I was confused why this one wouldn't.

Originally Posted by bakerman2

Can you post an example file with both codes in it to test.

Yes of course! Here it is. I deleted everything else that doesn't matter, and just left the toggles and everything needed to make this work.

I've tested the macro, and it still works fine when run manually, but it doesn't happen automatically like I want it to. I've also added the same named-ranges and all that jazz.

Originally Posted by protonLeah

Please Login or Register  to view this content.

So when I use the "Sub Worksheet_Change" in this code I get an "Ambiguous name detected" error, presumably because I call out this exact wording in another piece of code that also hides rows. IS there anyway around this?

Thank you so much for your help!!

Originally Posted by protonLeah

You didn't post the other code

Please Login or Register  to view this content.

Ahhh sorry! I didn't think I needed it. Here it is!

Please Login or Register  to view this content.

Originally Posted by protonLeah

Combining the two codes:

Please Login or Register  to view this content.

PERFECT!!! Works like a charm! I just had to swap the False & True statements (they were backwards), and delete the ' mark before the "Call AdjustRows(Target.Value)". Now everything works and happens automatically.

Thanks so much for your help!