Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

2nd go (can anybody help)

Status
Not open for further replies.

Roosters

Technical User
May 14, 2000
61
AU
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]
 
I 'think' I understand what you are trying to do. If we are on the same wavelength....

You need to have each set of option buttons in a different frame. The frame itself can be hidden so that it doesn't look like there are frames, but....

Option buttons work like a unit within a specific enviroment. Make a 'different environment', you can get more 'units'. [sig][/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top