Exactly what is the Worksheet activate Event? I am open to anything that will work the way I need it to.

As for the renewal I had played with a code for that as well wasn't 100% sure if I wanted to use it.