'Paste Special' problem with macro

I have a macro that copies the main report sheet in my workbook. The point of the macro is to get a copy of the report data without allowing anyone to see the formulas/data behind it - when it pastes, it pastes only the values in the tables and then copies the charts, deletes the live ones, and pastes only the images back on the sheet. The macro works on my computer and my partner's computer, but not on anyone else's. It stops at this point:

 ActiveSheet.PasteSpecial Format:="Picture (PNG)", Link:=False, _
        DisplayAsIcon:=False

and either gives them a runtime error or Excel stops working entirely (interestingly, this differs based on what type of computer they use).

Why does this happen? Does it have something to do with Excel settings?