I use the follow code on workbooks that have a ton of sheet tabs, it even show the hidden sheet tabs which is good. However when a hidden sheet is selected to goto, it fails. Is there a way to edit this so if a hidden tab is selected, it unhides it?
Private Sub cmdGoTo_Click()
If cboSheets.ListIndex <> -1 Then
Private Sub UserForm_Initialize()
Dim I As Long
For I = 1 To Worksheets.Count