Insert Image without local drive

[Dwergkip]

Hello everyone,

I'm finding trouble to insert an image from my USB / a certain folder.

After pressing a certain "Button" a certain image has to show.
But I have to send this Excel map to other people.
So is it possible to add a folder with images in it so the VBA can insert images from that folder?

Now I have to add images from my local drive, but this folder is never the same at other people's PC.

For example:

Sub Button()
ActiveSheet.Pictures.Insert ("Excelmap\Image1.Jpg")
End sub

So without C:\ProgramFiles\Documents\User

Is this possible?

Kind Regards

 

[Dwergkip]

Or perhaps, is it possible to just add the images in another sheet, and let them add from there?
If that is not possible, maybe even from within the same sheet?

 

[MichaelS94]

I would just import all the images you need into a separate sheet. You can then refer to the images on that sheet and it would be much easier than having to import all the images from a saved location everytime you open the spreadsheet.

So I would put all the images on a separate sheet and then hide the sheet containing the images when it is ready to send out to other people.