2010 VBA linking image instead of embedding it

[zduris]

Hi. I'm stomped. I wrote a nifty vba in Excel 2007 that lets people ebmbed an image from their c: drive as a proof that they've seen the and approve the spreadsheet. Everyone has their unique image on their c: drive, they click a button, and bam the image shows up...
We recently upgraded to excel 2010. My problem is that excel 2010 creates a link to the image rather than embeds it. So when I look at who approved the document, all the "signatures" are linked to my c: drive showing my unique image....help please! Here's the code I used:

ActiveSheet.Pictures.Insert ("c:\signature.Jpg")
ActiveSheet.Pictures(ActiveSheet.Pictures.Count).Select
With Selection
.ShapeRange.LockAspectRatio = msoFalse
.Height = 32
.ShapeRange.Width = 160
.Top = ActiveCell.Top + 3
.Left = ActiveCell.Left + 20
.Placement = xlMoveAndSize
End With

Thanks,
-Z-

 

[Saagar]

In case you are still looking for a solution, check this out:
http://social.technet.microsoft.com/Forums/en-US/excel/thread/10d6471d-09fa-4809-984a-b5613fad7287/

 

[zduris]

Thanks, I finally got around it by copying the image and pasting it back in without the link...here's the code I used.

ActiveSheet.Pictures.Insert ("H:\signature.Jpg")

ActiveSheet.Pictures(ActiveSheet.Pictures.Count).Select
ActiveSheet.Pictures(ActiveSheet.Pictures.Count).Copy
ActiveSheet.Pictures(ActiveSheet.Pictures.Count).Delete
ActiveSheet.PasteSpecial Format:="Picture (JPEG)", _
Link:=False, DisplayAsIcon:=False

 

[katcar]

I had same problem. Many thanks for code to resolve issue.