If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell References
I would like to be able to click in a cell and have it take me to another
page in the workbook - Any suggestions? Thank you. |
#2
|
|||
|
|||
Cell References
Yes. The following macro will take you to a sheet named "Whatever" if you
click on cell A1 of the active sheet. This is a sheet event macro and must be placed in the sheet module of your sheet. Access that module by right-clicking the sheet tab and selecting View Code. HTH Otto Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Not Intersect(Target, Range("A1")) Is Nothing Then Sheets("Whatever").Select End If End Sub "accessnovice" wrote in message ... I would like to be able to click in a cell and have it take me to another page in the workbook - Any suggestions? Thank you. |
#3
|
|||
|
|||
Cell References
Set Hyperlink.
Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "accessnovice" wrote: I would like to be able to click in a cell and have it take me to another page in the workbook - Any suggestions? Thank you. |
#4
|
|||
|
|||
Cell References
In Sheet1 cell A 6 type:-
=Sheet3!A6 In the same cell (Sheet1 cell A6) - right hand click once - click on Hyperlink - Insert Hyperlink should launch - select Place in This Document (by clicking it) on the left hand side - in the Type the cell reference: box (field) on the right hand side select A6 - select Sheet3 (for example) on the right hand side (by clicking on that option) - click OK - Sheet1 cell A 6 will now change format to show that a hyperlink has been added - Save the file (if required) Clicking in Sheet1 cell A6 will now take you to Sheet3 cell A6 automatically. If my comments have helped please hit Yes. Thanks. "accessnovice" wrote: I would like to be able to click in a cell and have it take me to another page in the workbook - Any suggestions? Thank you. |
Thread Tools | |
Display Modes | |
|
|