Opening Excel Spreadsheet on a tab

D

david.willis

Not really what I am looking for. As I will be displaying differen
sheets depending on what link is clicked, I don't need to have
default sheet, instead I need to specify a different sheet to b
displayed before excel is opened.

i.e. A link for the prices sheet opens the spreadsheet on the price
sheet, and straight after there is a link to the sales sheet, whic
opens the spreadsheet on the sales sheet on the spreadsheet.

Hope that makes more sense,

Dav
 
J

JE McGimpsey

One way:

If linking from Word, for example, add the sheet and cell as an anchor
to the URI. For instance:

file://localhost//Documents/XLFiles/Workbook3.xls#Sheet3!A1
 
Top