Hyperlink

[Tamm]

I have a hyperlink in another document that opens an excel
workbook. How do I make the link open a certian
spreadsheet in the workbook ??

Thanks

 

[Frank Kabel]

Hi
enter the hyperlink as follows
C:\temp\book.xls#sheet2!A1

 

[Gord Dibben]

Tamm

You can use VBA Workbook_Open code to go to the specific sheet.

With the target workbook open.......

Right-click on the Excel Icon at top-left corner of Menu Bar. Select "View
Code. Paste this code in there. Save the file.

Sub WorkBook_Open()
WorkSheets("Sheet2").Activate
End Sub

The "Sheet2" is example only. Your sheetname may differ. Adjust as needed.

OR use Workbook_BeforeClose code to set the worksheet as the active sheet upon
closing the workbooK.

Note: with either of the above methods the code goes into the ThisWorkbook
module, not a general or worksheet module.

Gord Dibben Excel MVP