Controls tab missing from "Format Controls" for Option Button

[Marc Hillman]

Excel 2007 under Vista
I am trying to set the "Cell Link" of a group of Option Buttons, but when I
right-mouse | Format Controls on the option button the "Controls" tab is
missing.

When I insert the control, I have the option to use Forms or ActiveX type
controls, but in either case the following is inserted
"=EMBED("Forms.OptionButton.1","")"

It looks like Forms type controls are added in regardless of whether I
select the Forms or ActiveX type.

Any clues?

 

[Ron de Bruin]

When I insert the control, I have the option to use Forms or ActiveX type

controls, but in either case the following is inserted
"=EMBED("Forms.OptionButton.1","")"

Working OK here

I see the control tab when I use the Forms option

When you use the ActiveX you can do it in the properties

 

[Marc Hillman]

Does not work OK here. I forgot to mention that I am editting an XL 2003
file in XL 2007 in case it's relevant.

 

[Ron de Bruin]

Also no problem here when I insert the option buttons in a 97-2003 file in 2007
I have no 97-2003 file created in 2003 with a option button to test on this machine.

If you want you can send it to my private address
http://www.rondebruin.nl/