You'd be better off using OptionButtons rather than CheckBoxes - they'r
mutually exclusive by design so when you click one the other i
deactivated.

Co

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=55879