Open Different Very Hidden Worksheets

[KLahvic]

Question: If I have a user form which has all 50 states with check boxes, when a user selects a state, how do I code it to just bring up the worksheet that relates to that state. I only wnat to allow one state viewing at a time, so I need to also figure out how to allow only one selection.

I havent designed the user form yet but I have the data and the workbook with all the worksheets completed.

Any help would be great.

Thanks in advance.

[KLahvic]

Or would it be easier with command buttos representing each state? If so, what would the code be for each button to open up a seperate worksheet within the workbook?

[graeme86]

Look at using Option Buttons and group them together. this will allow only one item to be selected at a time.