Thank-you Ron de Bruin for you help on the first question
and for and all of the other help you have given me and
others. It is truly appreciated.

Your last answer works great, but leads to a lot more.

1. When I turn off tools it is global or fixed in excel
until I turn it back on. Is there a way (without upon
open/close)for excel to revert back to the defult
settings upon close?

2. Is there a way to turn off the menu bar completly?

3. If I send this spread sheet to others with (Upon
open/close) is there any way that it would permenantly
change there settings?

Again, thanks a lot for you help.