I have a simple paste special macro assigned to a button image…
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False
So a user can copy data from an outside source and then select a cell in the workbook that will be compiled with padlock, click the macro button and the data is pasted in. It functions perfectly in the workbook before compiling, but after compiling it throws…
Error 1004: PasteSpecial method of range class failed
What setting would be causing the error after compiling?