Hi,
your best bet would be to change the checkboxes to option boxes as these
only allow to be selected at a time

hth

David

"neilb514" wrote in message
...
hi
I have six checkboxes in a spreadsheet. Only one can be checked at any one
time. ie If checkbox one is checked and i need to change to checkbox two
can
checkbox one be automatically unchecked.
Many thanks