Upon opening workbook, loop over certain sheets and apply macro

Hi all,

Thanks in advance for taking the time to read this. I am having difficulty with implementing an idea and am thankful for any help. To put it simply, I would like to have the following accomplished:

Upon opening the workbook, a macro searches for certain sheet names and then applies a different macro to those sheets. Here is what I currently have:

Please Login or Register  to view this content.

Upon opening the workbook, the code loops through each sheet name in the array and applies

Please Login or Register  to view this content.

to each one. The "In_Season" is a module that is called, seen below:

Please Login or Register  to view this content.

The ultimate purpose of this workbook is to open and send an email if any of the cells contain "alert" in either sheet. However, upon testing, the workbook seems to loop through only one of the sheets and sends two emails with the same sheet information. I have attached a sample file and have commented out the code so it does not automatically run. Simply input your own email address in the ".To" section to test.

Macro_Example.xlsm

Thanks again!

Shameless bump