access to hidden sheets

[KDS14589]

I have A combo box named comboWs that has a list of all 63 worksheets in the workbook, but all are hidden except the active one. Combo's output is on worksheet named general.switchboard in cell "O54" (this worksheet is visible=true). I want to go to the worksheet selected in the combo. I've tried several codes and even a few from the internet. Most from the net work with listbox's, user forms, or didn't connect to hidden sheets. I've tried to unhide the sheet by code first before selecting but that didn't work either. I'm at a point were the solution may be simple but I've tried so many times and with many codes I've started eating the Halloween candy that's for the kids. ::
Help!!!!!

 

[Fluff]

Is you combo an ActiveX, or Forms Control combo?

 

[James006]

Hello,

Have you tested

Private Sub ComboBox1_Change()
    Sheets(ComboBox1.Text).Visible = True
    Application.Goto Sheets(ComboBox1.Text).Range("A1")
End Sub

Hope this will help

 

[KDS14589]

STILL NO LUCK
my last try is

Private Sub gotoCombows_Click()
Sheets("general.switchboard").Range("O53").Visible = True
Application.Goto Sheets("general.switchboard").Range("A1")
End Sub

I tried your code but that didn't work either.
I've added a command button next to the combo box so I don't get a loop that freezes up my computer

 

[Fluff]

Assuming it's an activex combo (as you never answered my question).
Try

Private Sub [COLOR=#ff0000]comboWs[/COLOR]_Click()
    With Me.[COLOR=#ff0000]comboWs[/COLOR]
        Sheets(.Value).Visible = xlSheetVisible
        Sheets(.Value).Activate
    End With
End Sub

 

[KDS14589]

sorry I didn't answer.
I was distracted.
yes it is an activex.
and your code works.
thank you!!!!!
I'm sorry for the delay.

 

[Fluff]

Glad we could help & thanks for the feedback