I need to make three sets of 'option buttons' on the one worksheet.
The three 'sets' of option buttons need only return a number in three cells that a 'Log in' macro looks at and hides or displays relevent worksheets. The first set is working fine and was set up just adding option buttons and giving them a cell link (5 buttons returning 1,2,3,4 or 5 in the 'linked cell'). Now the problem starts, if I add another button it is linked automaticaly to the first sets 'linked cell' and if I change the 'linked cell' for the new button it changes the first five's as well. Also as a result the buttons act as one group ie. I can only select one button, not three (one from each set) as intended. I hope this makes sense.
Thanks Phil [sig][/sig]
The three 'sets' of option buttons need only return a number in three cells that a 'Log in' macro looks at and hides or displays relevent worksheets. The first set is working fine and was set up just adding option buttons and giving them a cell link (5 buttons returning 1,2,3,4 or 5 in the 'linked cell'). Now the problem starts, if I add another button it is linked automaticaly to the first sets 'linked cell' and if I change the 'linked cell' for the new button it changes the first five's as well. Also as a result the buttons act as one group ie. I can only select one button, not three (one from each set) as intended. I hope this makes sense.
Thanks Phil [sig][/sig]