Gurus,

I have a number of checkboxes in my spread sheet. However I would like 4 of them to act like the options button, whereas if checkbox 1 is checked (true), then checkboxes 2,3 and 4 become unchecked (false). The same holds true if checkbox 2 is checked, then the other 3 are unchecked, and so on.

Since I cannot "record" a macro for this, and I have not been able to find anything on this subject on this site, I have no clue on how to accomplish this.

To keep the spreadsheet looking consistent, I would rather not use the active x options button since I have already built this spread sheet.

Hopefully someone can help.

Thanks in advance,
Tim