I want to create a link to a worksheet in another workbook so that
when I click on the link it will pop up the worksheet in the other
workbook. For example, clicking on the link in workbook A will pop up
worksheet 5 in workbook B.

In workbook B enter this code in Thisworkbook module.

Private Sub Workbook_Open()
Sheets("Sheet5").Select
End Sub

Save and close workbook.

In a cell in Workbook A InsertHyperlinkExisting file or web page.

Drill down to Workbook B and OK

Note: you will get the hyperlinks can be dangerous to your health message.

To prevent that you need a registry hack

http://support.microsoft.com/?kbid=829072


Gord Dibben MS Excel MVP


On Mon, 26 Oct 2009 17:26:40 -0700 (PDT), pkt wrote:

I want to create a link to a worksheet in another workbook so that
when I click on the link it will pop up the worksheet in the other
workbook. For example, clicking on the link in workbook A will pop up
worksheet 5 in workbook B.