Word - hyperlink 2

[JoeSmoe55]

Is there a way to embed a hyperlink in a Word document pointing to an excel spreadsheet and specify which worksheet will be displayed when it is opened?

Currently I have a hyperlink to an Excel spreadsheet but i opens to the default spread sheet( Worksheet 1) and I would like it to open to a different worksheet.

Thanks,
Joe

 

[TonyJollans]

Hi Joe,

Add "#Sheet2!A1" (or any other address you want) at the end of the hyperlink.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[thegrover]

Go to your excel spreadsheet and open it. At the bottom you will see tabs for each sheet. Drag the sheet you want to open to the first position. Save.

 

[JoeSmoe55]

Thanks Tony,

That is awesome. Not that it is anything big but thanks it does exactly what I want it to do.

Grover,
I know what you are saying but that doesn't help me when I have multiple links pointed to the same spreadsheet wanting them to open up to different worksheets. Thanks for the post though.

God bless you both -
Joe