Cell References

[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.

 

[Otto Moehrbach]

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

 

[Ms-Exl-Learner]

Set Hyperlink.

Remember to Click Yes, if this post helps!

 

[trip_to_tokyo]

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.