In Excel 2003, why can't I format an option button like I could in Excel
2000? Before I could right click the button, format control, and there was a
control tab. In 2003 you have to be in "design mode" and right click,
properties and then you get a confusing properties box. I have a file that i
created with 2000 (old option buttons) and I tried to add more buttons using
2003 and now I have two different types of option buttons. Is there any way
to just go back to the old way of formatting option controls?

There's an optionbutton on the Forms Toolbar and an optionbutton on the Control
toolbox toolbar.

Each have different behavior. It sounds like you want to delete that option
button and add one from the forms toolbar.

coryrey wrote:

In Excel 2003, why can't I format an option button like I could in Excel
2000? Before I could right click the button, format control, and there was a
control tab. In 2003 you have to be in "design mode" and right click,
properties and then you get a confusing properties box. I have a file that i
created with 2000 (old option buttons) and I tried to add more buttons using
2003 and now I have two different types of option buttons. Is there any way
to just go back to the old way of formatting option controls?

--

Dave Peterson