Opening Worksheets

[doss04]

I am wanting to click on an acct name in one worksheet and have the acct
information worksheet pop up.
Example:

Worksheet 1: = ACCOUNTS
A
1 TPA
2 FVA
3 OAKS

If i click on FVA. Then the worksheet named "TPA INFO" will pop up. How can
this be done? Can it all be done in one workbook or does it need to be more?

 

[Sheeloo]

In Excel 2003 -

Go to the cell you want to click on to open another sheet..
Choose Insert|Hyperlink
Click on 'Place in this document' on the left...
Choose the Sheet you want... and cell within that sheet to select...
You can enter a friendly name in the text to display...

 

[ShaneDevenshire]

Hi,

The following code will do this, but you need to adjust the reference
A2:A100 to match where you list is:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
If Not Intersect(Target, [A2:A100]) Is Nothing Then
Sheets(Target).Activate
End If
End Sub

A simpler way is to put a formula in those cells that link to the other
sheets. Then if you press Ctrl+[ when you are on the formula it will take
you to the other sheet.

Thanks,
Shane Devenshire