XL2000 and Radio Buttons

[Dawn]

I created a form for my sales staff in Excell 2000. I
included some questions on the form that may be answered
by clicking on radio buttons to make a choice. This works
GREAT in regular .xls format.

The problem occurrs when I save the file as a template
(.xlt format). When saved as a template, a user can click
on a radio button for one question, and as soon as another
radio button for a different question, in a different cell
is clicked, all other radio buttons get un-checked.

I've checked everything, and the objects aren't linked,
there is no vb code indicating a link, and as I said, the
problem doesn't exist in .xls format.

Any suggestions on a source of the problem, and possible
fixes would be greatly appreciated.

Dawn

 

[Earl Kiosterud]

Dawn,

Presumably, you've used radio buttons from the Control Toolbox, not vanilla
ones from the Forms Toolbar. I don't know if those from Forms can be
grouped anyway. In Properties you use a common GroupName to group them.
Using radio buttons from the Control Toolbox, I've just tried saving as a
template, and the grouping worked when a new workbook file was created using
that template. XL 2002.

 

[Dave Peterson]

If you put the Forms toolbar optionbuttons (aka radio buttons) inside a group
box, then you can group those, too.

 

[Earl Kiosterud]

Dave,

Ya know, I was sure I'd grouped them before, and looked all around before I
posted. That neuron just wouldn't fire. Thanks. Maybe I need a bourbon.

 

[Guest]

Thanks for the suggestion. Someone in the office
suggested I try this too. I did, but still have the same
problem. I'm getting flummoxed over this one. :{

 

[Dave Peterson]

Make sure you have the optionbuttons totally within the groupbox.

If that wasn't it, what problem are you experiencing?

(or were you saying that someone suggested the bourbon solution, too!)