Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop Option Button unselecting one on different worksheet?
I have placed option buttons on multiple worksheets inside one workbook. I
need to be able to select an option button (setting its value to 'true') on one worksheet then go to the other worksheet and make a selection there; however, when I go to the second worksheet and make a selection it removes my selection from the first worksheet (essentially making my selection for the first sheet set to 'false'). How do I make the option buttons on each worksheet work independently from the option buttons on other worksheets? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop Option Button unselecting one on different worksheet?
Maybe both the optionbuttons are tied to the same linkedcell.
Rightclick on each and choose properties. Check out that linked cell property. Make sure that they don't point at the same cell. nesmith6866 wrote: I have placed option buttons on multiple worksheets inside one workbook. I need to be able to select an option button (setting its value to 'true') on one worksheet then go to the other worksheet and make a selection there; however, when I go to the second worksheet and make a selection it removes my selection from the first worksheet (essentially making my selection for the first sheet set to 'false'). How do I make the option buttons on each worksheet work independently from the option buttons on other worksheets? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Option Button to populate formula | Excel Discussion (Misc queries) | |||
Comman Button to Save Worksheet as Workbook | Excel Discussion (Misc queries) | |||
Linking one worksheet to another by click on a command button | Excel Discussion (Misc queries) | |||
How can I create a button to save one worksheet into a new workshe | Excel Discussion (Misc queries) | |||
Second option button disappears when I make another column | Excel Worksheet Functions |