Donkeyote, you've been a life saver upto now... I hope you can help once more my friend.

I made the last change you suggested and everything was working fine. Then I discovered that nothing works unless both workbooks are open. Can you take a look at those last two books I uploaded to see what the issue may be? Is there a work around?

Thanks to all of you that have helped me!!