I am trying to make a worksheet with check boxes in it. I would like for it to work this way. When one of the boxes is checked the box in the cell beside it is grayed out and can not be checked. For example Cell D2 and cell E2. When D2 check box is checked you can not check the one in cell E2, of if cell E2 is checked you can not check cell D2. I would like this to go on for all set's of check boxes that I may use on the sheet. I have tried putting in Option buttons, but no matter where they are located, only one of them can be checked. I have also tried the Marriott Boxes, and have found them too time consuming. You have to pick each cell individually and format the cell's one at a time. Any help would be greatly appreciated. Thanks in advance.

Dave.