Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

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

Re: HELP! PLEASE! Linking Graphics

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

Re: HELP! PLEASE! Linking Graphics

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

Re: autocad object -- should be linkable

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.