Cell References

  • Thread starter Thread starter accessnovice
  • Start date Start date
A

accessnovice

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