How to make a worksheet visible

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yosi_lb - 23 Jan 2007 18:39 GMT

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

Reply to this Message

Gord Dibben - 23 Jan 2007 20:00 GMT

Yosi

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

Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 20:39:23 +0200, "yosi_lb" <yosi_lb@bezeqint.net> wrote:Sub

>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

Reply to this Message

Rate this thread: