Open Hidden sheets to specific point

[rhani111]

Hi All,

Lets hope my internet won't crash before this one posts...AGAIN...lol

I have hidden sheets that I have got a macro to open once the button is selected, but I want the macro to open at a specific point.

Here is the END only of the macro

Sheet54.Visible = xlSheetVisible
Sheet2.Visible = xlSheetVisible
Range("C8").Select
End Sub

How do I do this, so that Sheet26 is the one that the macro opens at?

Thanks in advance
Sandi

[JMB]

At the end try using

Sheet26.Activate
Range("YourRange").Activate


"rhani111" wrote:

>
> Hi All,
>
> Lets hope my internet won't crash before this one posts...AGAIN...lol
>
> I have hidden sheets that I have got a macro to open once the button is
> selected, but I want the macro to open at a specific point.
>
> Here is the END only of the macro
>
> Sheet54.Visible = xlSheetVisible
> Sheet2.Visible = xlSheetVisible
> Range("C8").Select
> End Sub
>
> How do I do this, so that Sheet26 is the one that the macro opens at?
>
> Thanks in advance
> Sandi
>
>
> --
> rhani111
> ------------------------------------------------------------------------
> rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
> View this thread: http://www.excelforum.com/showthread...hreadid=556276
>
>

[rhani111]

Thank you ...Thank you...oh Thank you...


Worked perfectly!!!!!
Sandi