Button To Move To A New Sheet

[rockyw]

Can I make a button that will move me from sheet 1, to sheet 15. I want to make a chart using data on sheets 1 thru 12. The chart will be on sheet 15, can I put a button that will jump to 15, then a button on 15 that goes back to 1? If I could edit that macro I can set it up for sheet2 to 15 and back ect. Thanks

 

[GTO]

...I believe I misunderstood and Peter is spot on.

 

[VoG]

Try like this with a button from the Controls toolbar

Private Sub CommandButton1_Click()
Sheet1.Select
End Sub

 

[Cease]

You can make a text box, then assign a hyperlink to it (one of the right click options).

From there you can choose for it to be in "a place in this document" and from there it will let you choose which sheet you want to link it to.

On the destination page you can repeat the process to "travel" back.

Hope it helps!

 

[rockyw]

Thanks both great ideas that work. Now I can get on with a project. Have a great day.