Thanx for that it worked a treat!

Although I could use the Validation tool within Excel I am happier
having this code running in the background - I am supposed to be
demonstrating the amazing capabilities of VBA (mainly so I can push
an
upgrade from 97!!)

Thanx again.

o.k. thats a good reason :-)
and thanks for the thanks
Frank