How to make a worksheet visible

Y

yosi_lb

hi
I have about 40 worksheets in a workbook. each sheet has a name of a student
in a classroom.
how can I programaticy make a choosen sheet to be visible

thanks
 
G

Gord Dibben

Yosi

Sub unhide()
Dim whichname as String
whichname = InputBox("type in name")
Worksheets(whichname).Visible = True
End Sub


Gord Dibben MS Excel MVP
 
Top