Hyperlink to Embedded Object

[Gary''s Student]

One of our people has embedded several Word docs and PowerPoint files in a
workbook. She would like to put hyperlinks to the objects elsewhere in the
workbook. The goal is that the user can click the hyperlink and the embedded
object opens.

She does not care if the hyperlinks are created with Insert > Hyperlink or
the HYPERLINK() function.

I know how to hyperlink to another file or hyperlink to a cell in the
workbook, but not to an embedded object in the workbook.

Any ideas??

 

[Gary''s Student]

Great idea.

I'll hyperlink to some distant cell and the use the selection change event
to trigger your macro.

Thanks!