Option Buttons -ActiveX
 

I created 3 ActiveX Option buttons on a sheet.
From the Properties Window of each I blanked out the Default GroupName
Sheet1 They still are mutually-exclusive - Is this by design?
Just playing around I was trying to make all (3) true.
Can it be done?
TIA,

Option Buttons -ActiveX
 

Hi,

Try giving each one a unique name.

Although it sounds like you should be using the checkbox controls.

Cheers
Andy

Jim May wrote:
I created 3 ActiveX Option buttons on a sheet.
From the Properties Window of each I blanked out the Default GroupName
Sheet1 They still are mutually-exclusive - Is this by design?
Just playing around I was trying to make all (3) true.
Can it be done?
TIA,


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Option Buttons -ActiveX
 

They a
OptionButton1
OptionButton2
OptionButton3

(Name) and Caption

"Andy Pope" wrote:

Hi,

Try giving each one a unique name.

Although it sounds like you should be using the checkbox controls.

Cheers
Andy

Jim May wrote:
I created 3 ActiveX Option buttons on a sheet.
From the Properties Window of each I blanked out the Default GroupName
Sheet1 They still are mutually-exclusive - Is this by design?
Just playing around I was trying to make all (3) true.
Can it be done?
TIA,


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Option Buttons -ActiveX
 

Hold On !!! - But in the Formula Bar they are
ALL=EMBED("Forms.OptionButton.1","")
But -- Can't Change


"Andy Pope" wrote:

Hi,

Try giving each one a unique name.

Although it sounds like you should be using the checkbox controls.

Cheers
Andy

Jim May wrote:
I created 3 ActiveX Option buttons on a sheet.
From the Properties Window of each I blanked out the Default GroupName
Sheet1 They still are mutually-exclusive - Is this by design?
Just playing around I was trying to make all (3) true.
Can it be done?
TIA,


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Option Buttons -ActiveX
 

I meant a unique Groupname.
Setting them all to blank causing them to be in a group with no name.

Cheers
Andy

Jim May wrote:
They a
OptionButton1
OptionButton2
OptionButton3

(Name) and Caption

"Andy Pope" wrote:


Hi,

Try giving each one a unique name.

Although it sounds like you should be using the checkbox controls.

Cheers
Andy

Jim May wrote:

I created 3 ActiveX Option buttons on a sheet.
From the Properties Window of each I blanked out the Default GroupName
Sheet1 They still are mutually-exclusive - Is this by design?
Just playing around I was trying to make all (3) true.
Can it be done?
TIA,


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Option Buttons -ActiveX
 

osso, grasshopper... hummmmmmm (From the old Kung Foo days -- LOL)
Thanks Andy,

"Andy Pope" wrote:

I meant a unique Groupname.
Setting them all to blank causing them to be in a group with no name.

Cheers
Andy

Jim May wrote:
They a
OptionButton1
OptionButton2
OptionButton3

(Name) and Caption

"Andy Pope" wrote:


Hi,

Try giving each one a unique name.

Although it sounds like you should be using the checkbox controls.

Cheers
Andy

Jim May wrote:

I created 3 ActiveX Option buttons on a sheet.
From the Properties Window of each I blanked out the Default GroupName
Sheet1 They still are mutually-exclusive - Is this by design?
Just playing around I was trying to make all (3) true.
Can it be done?
TIA,


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info