You need some VBA code to do that. See this thread:
http://tinyurl.com/4p5esj
--
Biff
Microsoft Excel MVP
"Bob Arnett" wrote in message
...
Thanks, that did the trick.
I was also wondering if it is possible to make the line around the group
box
not show like one can do with text boxes, cells, etc.
"Bob Arnett" wrote:
I have two completely unrelated user-defined options on the same
worksheet
with each option having a YES radio button and a NO radio button.
Unfortunately, I can't seem to get Excel to recognize that there are two
independent questions being answered and therefore if any of the four
options
is selected the other three are deselected. Is there a way to do this?