MrExcel Publishing
Your One Stop for Excel Tips & Solutions

HELP! PLEASE! Linking Graphics


Posted by Jan on January 17, 2002 9:08 AM

Does any one know if there is a way to link graphics on one worksheet to another worksheet as you would with text and the {paste link} command?

Thanks


Posted by Damon Ostrander on January 17, 2002 9:29 AM

Hi Jan,

Just right-click on the graphic (a Shape object), select hyperlink in the shortcut menu, then in the "Link to:" column select "Place in this document", etc.

Damon

Posted by Jan on January 17, 2002 10:46 AM

what if it's a different kind of object, in my case it is an autocad object. that i want to link to my other sheets

Posted by Damon Ostrander on January 17, 2002 10:52 PM

Re: autocad object -- should be linkable

Hi again Jan,

With most objects--and this probably applies to an autocad object--you can right-click on the object and Excel will allow you to assign a macro from the shortcut menu. So if you want the same effect as a hyperlink, you can simply assign it to a macro that looks like this:


Sub GoToWS1B4()
Worksheets(3).Activate
[b4].Select
End Sub

This macro selects cell B4 on worksheet 3. You could just as easily have it activate the cell, or perhaps select some other autocad object, etc. The macro should be placed in a macro module, not in the worksheet's event code area.

Damon