![]() |
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) |
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