Button To Move To A New Sheet

rockyw

Well-known Member
Joined
Dec 26, 2010
Messages
1,196
Office Version
  1. 2010
Platform
  1. Windows
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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
...I believe I misunderstood and Peter is spot on.
 
Upvote 0
Try like this with a button from the Controls toolbar

Code:
Private Sub CommandButton1_Click()
Sheet1.Select
End Sub
 
Upvote 0
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!
 
Upvote 0
Thanks both great ideas that work. Now I can get on with a project. Have a great day.
 
Upvote 0

Forum statistics

Threads
1,219,096
Messages
6,146,276
Members
450,682
Latest member
augusto89

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
Back
Top