Dependent checkboxes where only one can be checked at a time.

Hi All,

I know this topic has been posted elsewhere and I've tried a few of the solutions, but none have worked the way I'd prefer. I know I can use option buttons, but (1) I like the way the checkboxes look better and (2) I have dependent checkboxes on multiple sheets (haven't attempted to use option buttons for this). I'm using 20 checkboxes in total at the moment that I want to be dependent. The current Macro I'm using says:
If CB1 is true then
make all others false
else
if CB2 is true
make the others false
else
and so on.

This works well if you check CB1 first, then check CB2 next. It will then uncheck CB1. But, if you check CB2 first, it will not let you check CB1. Instead, you have to uncheck CB2, then check CB1. This does work, but is a little clumsy.

Hope some of you guys (or gals?) can help.

Thanks!