Thread: Open Hidden sheets to specific point
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
  
Posts: 2,062
Default 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


Reply With QuoteReply With Quote