Hi Dave,

I'm using your first suggestion and it works great! Thankyou very much.

I can't figure out why my way wasn't working though. I managed to get it
showing the Userform but not exiting Book1, or exiting Book1 but then it
wouldn't show the userform......grrr...

Anyway, your suggestion works a charm. Thanks again.