[Fred[_5_]]

I can insert a hyperlink to open an Excel workbook but is there any way to
use the hyperlink to open the Excel workbook on a particular worksheet?

Thanks,
Fred

[Herb Tyson [MVP]]

Copy the Excel bits to the clipboard. Then, in Word, choose Edit - Paste
Special. Select Paste Link.

When I do that, I can go directly to the source of the paste (in Excel) by
right-clicking the object in Word, and choosing Linked Worksheet Object -
Edit link or Open link.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Fred" leavemealone@home wrote in message
...
I can insert a hyperlink to open an Excel workbook but is there any way to
use the hyperlink to open the Excel workbook on a particular worksheet?

Thanks,
Fred

[Fred[_5_]]

Thanks Herb, that works perfectly.


"Herb Tyson [MVP]" wrote in message
...
Copy the Excel bits to the clipboard. Then, in Word, choose Edit - Paste
Special. Select Paste Link.

When I do that, I can go directly to the source of the paste (in Excel) by
right-clicking the object in Word, and choosing Linked Worksheet Object -
Edit link or Open link.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Fred" leavemealone@home wrote in message
...
I can insert a hyperlink to open an Excel workbook but is there any way to
use the hyperlink to open the Excel workbook on a particular worksheet?

Thanks,
Fred