Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Option Buttons 'cell link'

Option Buttons 'cell link'

Option Buttons 'cell link'

I need to add three sets of option buttons to one worksheet. The problem is after adding my first set of buttons I can't seperate the other sets 'cell link' from the first.

RE: Option Buttons 'cell link'

Could you tell us what you are trying to do with the option buttons?  Do the first set of buttons do what they are supposed to do?  How do you create the next set?


RE: Option Buttons 'cell link'

The three sets of option button need only return a number in three cells that a 'Log in macro' looks at and hides or displays relevent worksheets. The first set are working fine and were set up just adding option buttons and giving them a cell link (three buttons returning 1,2 or 3 in the 'linked cell') if I add another button it is linked automaticaly to hte first sets 'linked cell' and if I change its 'linked cell' it changes the first three as well. I hope this makes sense Kathryn.
Thanks Phil

RE: Option Buttons 'cell link'

Sorry for the delay; I have been out on vacation.  I understand the functionality of the buttons; I think there might be a much easier way to do this.

I understand that you have a macro that is used to "log-in" users.  It sounds like you want to show or hide certain sheets based on user log-in.  Do your option buttons decide what is shown or hidden?  In other words, when I as a user open your workbook, am I going to see a form with three different sets of option buttons like:

Option Group 1   Option Group 2  Option Group 3
  o Option 1A      o Option 2A     o Option 3A
  o Option 1B      o Option 2B     o Option 3B
  o Option 1C      o Option 2C     o Option 3C
  o Option 1D      o Option 2D     o Option 3D

Let me know the answers to these, if you still need help on this problem.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close