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:

Some videos you may like

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,539
Messages
5,625,404
Members
416,100
Latest member
lirongr1996

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