want to create a link to another worksheet in another workbook

  • Thread starter Thread starter pkt
  • Start date Start date
P

pkt

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 Insert>Hyperlink>Existing 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
 
Back
Top