How to insert a company logo image on a chart when the image is located on a worksheet as an inserted picture

[smdexcel]

I am able to place a logo image into the chartarea of a chart easily using

With ActiveChart.Shapes
.AddPicture "M:\coding\graphics\ma_logo.gif", False, True, ChartWidth - 120, 1, 90, 25
End With


But i would like to know how to go about inserting an image in the chartarea from a hidden worksheet .

Was thinking Something like the following :

Dim LogoPic As Picture
Set LogoPic = ActiveWorkbook.Worksheets("Hidden").Shapes("Picture 1").Copy

Then insert the picture at a specific location -
but i am having some difficulty determining how to go about this - I would appreciate any asisstance - Thanks

 

[smdexcel]

I am attempting to use the following code insert two pictures that have been stored on a hidden worksheet -

Sub WbCopyLogos(ChartNumber As Integer)

Dim wb As Workbook
Dim sh As Shape
Dim LogoPic As Picture
Dim TargetWS As String
Dim item As Integer
'Dim ChartNumber As Integer
'Dim Chartname As String

For Each sh In ActiveWorkbook.Worksheets("Hidden").Shapes
If sh.Type = msoPicture Then
sh.Copy
ActiveSheet.ChartObjects(ChartNumber).Activate
With ActiveChart
.Paste
End With
End If
Next

---- Can you please tell me why this will not work ..

Thanks you, in advance, for your help .