Insert a Linked Image using Macros (VBA) in Excel Office 365!!
Tags: insertalinkedimagein, vbamacros
Published: 2021-01-26 08:44:26

---
title: Insert a Linked Image using Macros (VBA) in Excel Office 365!!
published: true
date: 2021-01-26 03:46:41 UTC
tags: InsertaLinkedImagein,VBAMacros
canonical_url: https://geekexcel.com/insert-a-linked-image-using-macros-vba-in-excel-office-365/
---

Do you want to know how to create a linked image in Excel? don’t worry we will introduce a great feature of Excel that is [VBA](https://geekexcel.com/excel-office-365-vba-overview-definition-and-examples/) and Macros. Using it we will quickly **Insert a Linked Image in Excel Office 365**. Lets us see the steps needed to create a linked image.
## Steps to Insert a Linked Image using Macros:

To create a linked image on your worksheet using Macros, follow the below instructions.

- On the **Developer Tab, select** the **Visual Basic** option under the **Code** section.

![Select Visual Basic option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Select-Visual-Basic-option-5.png)<figcaption id="caption-attachment-14839">Select the Visual Basic option</figcaption>

- You need to activate the sheet where you want to insert a linked image in Excel.
- Now, enter the below code.

VBA code to insert linked image using Macros

‘Ensure that you have a selected range

Sub InsertALinkedImage()

Selection.Copy

‘You need to paste the selection as an image

ActiveSheet.Pictures.Paste(Link:=True).Select

End Sub

- You need to **save the code** by selecting it. Then **close** the **window.**

![Save the code](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_EpUyZX7ZZO.png)<figcaption id="caption-attachment-21429">Save the code</figcaption>

- You have to open the sheet containing the data. On the **Developer Tab, choose** the **Macros option** in the **Code** section.

![Choose the Macros option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-the-Macros-option-3.png)<figcaption id="caption-attachment-14841">Choose the Macros option</figcaption>

- You need to make sure that your macro is selected and **click** the **Run** button.

![Click Run button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_2p0rQQqbkC.png)<figcaption id="caption-attachment-21430">Click Run button</figcaption>

- Now, you will see the created linked image as shown in the below screenshot. You can double-click on it to navigate to that specific page.

![Click here](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_Pfix6VezIY.png)<figcaption id="caption-attachment-21431">Click here</figcaption>

## Verdict:

From this post, we guided you to learn the steps to **Insert a Linked Image in Excel Office 365**. Drop your **worthwhile feedback** with us in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Excel VBA Date And Time Function in Office 365 ~ Easy Tutorial!!](https://geekexcel.com/excel-vba-date-and-time-function/)
- [How to Add Date in Footer using Macros (VBA) in Excel Office 365?](https://geekexcel.com/how-to-add-date-in-footer-using-macros-vba-in-excel-office-365/)
- [Excel Office 365 VBA Variables & Data Types – A Complete Guide!!](https://geekexcel.com/excel-office-365-vba-variables-data-types-a-complete-guide/)