Option buttons

[ElvisSteel]

I have a worksheet used for data entry, and I want to use option buttons against a number of items.
However when I set the "Cell Link" address for one set of option buttons, it sets the same address for all of the other buttons. How can I separate the groups of buttons?
Hope that makes sense. I can provide more information if required.

 

[PCL]

It looks like buttons are grouped.
Select the group, right clic:
Grouping > Ungroup

 

[ElvisSteel]

Thanks for your prompt reply, but buttons are not grouped (as in I have not made a conscious effort to group them via right-click,grouping,group)

I have an intial set of three buttons, say options 1,2 and 3. These are all pointing to the same cell link (which is what I want). However, when I add a second set of 3 buttons, say options A,B and C, they automatically pick up the same cell link.

When I change the cell link for one of the buttons, all of the other buttons get the same new link. I want to be able to point 1,2,3 at on link and A,B,C at a different link.

Currently no matter how many buttons I put on my sheet, they are all treated as one group, ie. I can only select one button on the entire sheet, and they all get the same cell link, regardless of which one I change.


Steve

 

[pcc]

put a group box round each group that you want to act as a group

 

[ElvisSteel]

Thanks very much - so simple I completely missed it