Excel 2007 Macro to add photo

  BrendanKK 17:18 PM 06 Feb 12

I have created a macro to add a photo to an Excel 2007 workshet and added a link to the macro to the Quick Access Toolbar. However when I click the icon on the Quick Access Toolbar to add the picture, nothing happens.

The same procedure works fine in Word 2007. What is different with Excel?

  Noldi 18:27 PM 06 Feb 12

I think if you copy and paste your macro on here I'm sure somebody will sort it out.


  BrendanKK 13:45 PM 17 Feb 12

I create macro using the following steps: DEVELOPER Tab > Record Macro > (Input Macro name "Signature" ) > OK INSERT Tab > Picture > (Click on "Signature" picture file to import) DEVELOPER Tab > Stop Recording.

The Macro reads as follows

Sub Signature() ' ' Signature Macro '

' End Sub

When I run Macro nothing happens

  VoG II 14:47 PM 17 Feb 12

The macro recorder has not captured anything. You need something like

Sub piccy()

ActiveSheet.Pictures.Insert ("C:\example\pic.jpg")

With ActiveSheet.Shapes(ActiveSheet.Shapes.Count)

.LockAspectRatio = False

.Top = Range("C3").Top

.Left = Range("C3").Left

.Height = Range("C3").RowHeight

.Width = Range("C3").Width

End With

End Sub

  BrendanKK 15:04 PM 17 Feb 12

Vog, As always your a star.

Thank you. B


This thread is now locked and can not be replied to.

Best Cyber Monday deals 2015 live blog: Best UK Cyber Monday tech deals, sales, discounts & offers

1995-2015: How technology has changed the world in 20 years

#AdventSauceJoyMince - generate a gratuitous Christmas tweet for #GivingTuesday charity

New MacBook Air release date, specs and rumours: 11in MacBook Air to be discontinued