Auto-activation script

[Skorpionkz]

Hi guys,

I found script which trigger the macro when they are changed

Please Login or Register  to view this content.

But this actually not what I need

I need 1 more line which will check if any of cells in range B24:B26 is equal to "None" and if "yes" then do nothing if "No" then do same think that above script is doing.

I tried to change it by myself but it is not working

Please Login or Register  to view this content.

Can some one correct this?

Thank you

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.