Open Hidden sheets to specific point
 

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

Open Hidden sheets to specific point
 

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

Open Hidden sheets to specific point
 

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


Worked perfectly!!!!!
Sandi


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=556276