Insert a Linked Image Using Macros In Excel

Make sure your Excel has the Developer Tab enabled following this tutorial.

I explain how you can do this below step by step!

What does it do?

Creates a linked image based on your selection

Copy Source Code:

</p>
<p>'Make sure you have a selected range first<br />
Sub InsertALinkedImage()</p>
<p>Selection.Copy<br />
'Paste the selection as an image<br />
ActiveSheet.Pictures.Paste(Link:=True).Select</p>
<p>End Sub</p>
<p>

Final Result: 

Exercise Workbook:

Download excel workbookInsert-a-Linked-Image.xlsm

Let us try creating a linked image based on the logo. You can do this on any part of the spreadsheet!

STEP 1: Go to Developer > Code > Visual Basic

STEP 2: Paste in your code and Select Save. Close the window afterwards.

STEP 3: Let us test it out!

Open the sheet containing our target. Go to Developer > Code > Macros

Make sure the logo cells and your macro are selected. Click Run.

With just one click, you have created a linked image! Double click on it and it will highlight the logo!

How to Insert a Linked Image Using Macros In Excel

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.