Hyperlink Cell to a Shape

I had help getting a hyperlink from a Shape to a Cell on seperate worksheets and the macro works fine:

Please Login or Register  to view this content.

Now I attempted to reverse this to hyperlink a Cell to a Shape.
I has the failed.
Reversing the above is harder than I had thought.
Notice how it has grown in character length. LOL

Please Login or Register  to view this content.

The above creates a hyperlink but it is invalid. It doesnt create a correct hyperlink.
The variable shp.Name only appends the name to the hyperlink, not its location.
Thus my problem. How to set the location?

Any hints, tips or examples are welcome.

Cross posted at:
http://www.microsoft.com/office/comm...d-7011e63326b6

follow link for solution
http://www.excelforum.com/excel-prog...ml#post2258797

You have this sorted, Rick?

If not, you could just put the shape name in the cell, and use the selection change event to select the named shape on the desired sheet.

Originally Posted by shg

You have this sorted, Rick?

If not, you could just put the shape name in the cell, and use the selection change event to select the named shape on the desired sheet.

This was the route I took, I think you mentioned something similar (if not the same) and Gary's Student on the crossed post site mentioned the same.