Option Buttons/Radio Buttons

[John Calder]

Hi

I run Excel 2000

I have 2 option buttons in each row (total of 20 rows)


I would like the only one of the 2 buttons in each row are on or off.

The problem I am having is that it dosent matter which button on which row I
select, only that button is active. All the other buttons go blank.

I have tried changing the source for each pair of buttons but when I do all
the other button sources change as well.

How do i set up the buttons so that I can select one of the 2 in every row.?

Example

20 buttons in total - 10 buttons active and 10 buttons inactive


Thanks


John

 

[T. Valko]

You have to group them by putting each set in a group box from the forms
toolbar.

 

[John Calder]

Thanks !

That has put me in the right direction. However I cant seem to re-format the
group box outline so that I cannot see it on the screen. I can re-format it
so that it does not print out but I would like the user not to be able see
the actual outline of the group box on the screen.

Thanks

John

 

[T. Valko]

I don't know why MS didn't include the option to format the group box
borders!

You can hide then with some VBA:

Open the VBE editor: hit ALT F11
Goto View>Immediate Window
At the end of the list of commands type:

ActiveSheet.GroupBoxes.Visible = FALSE

Hit ENTER

To reverse, follow the same steps but type:

ActiveSheet.GroupBoxes.Visible = TRUE

Hit ENTER

 

[John Calder]

That works great !...thanks !

I only have one more problem then I am done ( I Think !)

I have approx 30 pairs of grouped buttons. They all work fine.

The problem occurs when I try to protect the sheet. Even if I set every
button format control to unlock the protection on it, after I apply the sheet
protection I get an error message telling me I cannot change the bottons as
the sheet is protected every time I select a button.

I even tried taking the protection off the cells that the buttons reside in,
but that didnt make any difference either.

I really need to protect the sheet as there are a number of formulas that
need protecting.

Any Idea what the problem is?

Thanks

John

 

[Dave Peterson]

If you have those buttons linked back to a cell, then that cell will have to be
unlocked.

Maybe you could put all the linked cells in a single column and hide the column
to make it more difficult for users to screw with those values.

Or maybe you could put the linked cells on a different worksheet (and hide that
worksheet).

 

[John Calder]

Dave

Thanks for your response. The buttons were indeed linked to a cell and once
I unlocked them it solved the problem. I have followed your advice and hiden
the column with the linked cells.

Thanks to both of you for your help, it is much appreciated.

John

 

[T. Valko]

You're welcome. Thanks for the feedback!

And, thanks to Dave for pitchin in with the assist!