Checking Ranges on multiple sheets in the Private Module...

[yunesm]

Hello,
I have a some code that I put together in the Private Module of the Workbook Object that works great one one sheet to activate calendar userform.

This code works:

Please Login or Register  to view this content.

But I also have two ranges to check on sheet-1.

Please Login or Register  to view this content.

Alone these both work fine. I'm trying to get my code to work for all ranges on both of the sheets and I'm failing miserably. I've been working on it for a while and I'm finally going to ask for help.

Any thoughts would be greatly appreciate.
Thanks!

[shg]

Try this:

Please Login or Register  to view this content.

[yunesm]

Perfect! This is exactly what I needed!!
Thanks!