Intermittent error, Method 'Copy' of object 'Shape' failed

[sparky2205]

Hi folks,
I've had a lot of help from the forum with the file in this link: List of Hazardous Substances - MrExcel.xlsm to get me to this point.
The original post was titled "Insert a picture from another worksheet".
But now that I'm almost there I have one final problem that I can't resolve.
The spreadsheet is designed to get the correct pictogram from a hidden sheet called Pictograms when the button on the worksheet Tabelle2 is pressed.
The problem is that intermittently it throws a runtime error "Method 'Copy' of object 'Shape' failed" on the line ThisWorkbook.Worksheets("Pictograms").Shapes(BEZEICHNUNG).Copy
There is no pattern to when this happens. It is totally random. Sometimes the file will also close during execution.
The Pictograms sheet is hidden and password protected with password - Test - but I don't think this is the issue as it works fine sometimes.
@GWteB helped me previously by building a checker for this issue but the problem still persists.

Any help would be much appreciated with this.
If any clarifications are required let me know.

 

[Marc L]

Hi, first check the content of the variable …​

 

[sparky2205]

Hi Marc,
could you be a little more specific?
I'm not a newbie with vba but I'm not at the level of you gurus either.

 

[GWteB]

Hi @sparky2205 ,
I'm gonna respond within the other thread in a short while ...

 

[Fluff]

Duplicate to: Insert a picture from another worksheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.