How to make a worksheet visible

[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

 

[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