Group them. If forms optionbuttons, then draw a frame or group box around
connected buttons, if control toolbox buttons, set the GroupName property
--
HTH

Bob Phillips

"Ciara" wrote in message
...
I have set up a spread sheet with five option boxes so that only one can
be
highlighted at one time.

I now want another set on the same spread sheet. If I draw a new option
box
and select it - it deselects all the others.

Any ideas on how to set up different option boxes groups -

- one set only allows one to be selected at a time
- Another will allow both to be selected etc.....