Need a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris D - 23 May 2008 22:06 GMT

hello,

In my worksheet I have a number of hidden sheets.
I need a macro in which I can select 1 of the hidden sheets, and unhide it.
Can anyone help?

thanks.

chris

Reply to this Message

Don Guillett - 23 May 2008 22:11 GMT

Sub unhidesheet()
mysheet = InputBox("Enter sheet NAME")
Sheets(mysheet).Visible = True
End Sub

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> hello,
>
[quoted text clipped - 6 lines]
>
> chris

Reply to this Message

Chris D - 24 May 2008 16:06 GMT

Thanks, that works.
1 detail to solve:
suppose I have hidden sheets named " 1", "2" etc.
I just ran nthe macro and unhided sheet "2", is it possible to make the just
insered sheet active?

> Sub unhidesheet()
> mysheet = InputBox("Enter sheet NAME")
[quoted text clipped - 11 lines]
> >
> > chris

Reply to this Message

Rick Rothstein (MVP - VB) - 26 May 2008 07:09 GMT

After you make the sheet visible, execute this statement...

Sheets(mysheet).Select

Rick

> Thanks, that works.
> 1 detail to solve:
[quoted text clipped - 18 lines]
>> >
>> > chris

Reply to this Message