run-time error '1004': Paste method ow Worksheet class failed

[r_simpson42]

One user (of many) receives the run-time error '1004': Paste method of Worksheet class failed
on the line "ActiveSheet.Paste" (see below for example macro)
I have many users here at work that use a whole slew of these types of macros as tickmarks in their Excel workpapers. They work for everyone, except one.
The macro is supposed to paste a small image (.png) into the excel worksheet.
Any ideas what could case this?
The macro is written in the below fashion in order to display the image on computers that do not have the macros and .png files installed on them.
Sub Senior_Ties_to_Prior_Year()
'
' Senior_Ties_to_Prior_Year Macro
'
'
ActiveSheet.Pictures.Insert("C:\Tick marks\Green Prior Year.png").Select
Selection.CopyPicture
Selection.Delete
ActiveSheet.Paste
ActiveCell.Select
End Sub

Thank you for your thoughts and suggestions!

 

[Michael M]

Do they have a protected worksheet ??
Have you tried pasting before deletion ?

Sub Senior_Ties_to_Prior_Year()
ActiveSheet.Pictures.Insert("C:\Tick marks\Green Prior Year.png").Select
Selection.CopyPicture
ActiveSheet.Paste
Selection.Delete
End Sub

 

[r_simpson42]

No, the worksheet is not protected, and sometimes the macro does work and sometimes he get the error.
It looks to me like I am pasting before deletion...so not sure what you mean.

 

[Michael M]

your code does this !

Selection.CopyPicture
[color=red]Selection.Delete
ActiveSheet.Paste[/color]
ActiveCell.Select

I suggested reversing the 2 lines in red !