Hi,
I have the below code that selects the sheet from a dropdown list box as selected by the user. How can I modify it so that it unhides hidden sheets first - as at present im just getting an error if the selected sheet is hidden.
![]()
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$E$10" Then Sheets(Range("E10").Value).Select End If End Sub
Bookmarks