My macro only works manually

Hi,

I have a created a different macro in three separate sheets. The macro in my first sheet works correctly. I choose an option from my combo box and the macro runs automatically when I change it. In the other two sheets, although the code is constructed the same way, I need to click: Macro, Select the Macro, and Run. for it to work.

What do I have to correct for it to be automatic like the first?
It's all in Module1 General

Please Login or Register  to view this content.

Then in each Sheet I have:

Please Login or Register  to view this content.

Hope you can help. Thanks!

The code is not exactly the same in the three sheets. It hides different rows. So what do I have to do to make it automatic?

Then just put the code in the Sheet's code if an ActiveX control. If it is a Forms control then put it in a Module.