ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Command Button to Hyperlink to a Different worksheet (https://www.excelbanter.com/excel-programming/328612-command-button-hyperlink-different-worksheet.html)

Mikeyboy

Command Button to Hyperlink to a Different worksheet
 
I would like to use a command button to hyperlink to a particular page within
a workbook (and maybe a specific Cell)

Mike Fogleman

Command Button to Hyperlink to a Different worksheet
 
It would be simpler to use a Forms Button, but for a CommandButton put this
in a general module:

Sub navsheet4()
Worksheets("Sheet4").Activate 'change to your sheet
Range("AA600").Select 'change to your cell
End Sub

With your CommandButton on sheet 1, put this in the Sheet1 code module

Private Sub CommandButton1_Click()
Call navsheet4
End Sub

Mike F
"Mikeyboy" wrote in message
...
I would like to use a command button to hyperlink to a particular page
within
a workbook (and maybe a specific Cell)





All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com