Button To Move To A New Sheet

rockyw

Well-known Member
Joined
Dec 26, 2010
Messages
1,191
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
 
Last edited:

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try like this with a button from the Controls toolbar

Code:
Private Sub CommandButton1_Click()
Sheet1.Select
End Sub
 

Cease

Board Regular
Joined
Dec 28, 2010
Messages
112
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

Well-known Member
Joined
Dec 26, 2010
Messages
1,191
Thanks both great ideas that work. Now I can get on with a project. Have a great day.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,657
Messages
5,838,635
Members
430,558
Latest member
Krampus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top