Help! Activate worksheet from a listbox

N

NightProbe

Is it possible to have a worksheet (from a multiple worksheet
workbook) popup as the active worksheet by selecting its name from
within a listbox or combo box? I want to hide all the worksheets and
provide a way that a particular worksheet is shown and then hid again
after use. I can't seem to find any information on how to do this if
at all possible. Any help will surely be appreciated!
 
B

Bob Phillips

Something like

With Worksheets(Listbox1.Value)
.Visible = True
.Activate
End With

but you can't hide them all, at least one must be visible
 
Top