Macro to copy and assign other macros

Hello,

I'm trying to create a macro (M1) where I copy everything from one sheet (A) to another sheet (B). In sheet A there are a number of buttons that have macros assigned to them. When copying all data from A to B, the buttons are also copied. For the copied buttons to work in sheet B, they need to be assigned to a macro (M2) specific for that sheet (B), and this action is also included in the macro (M1).

When I record the macro (M1) everything works fine, but when I try running the macro (M1), it looks very strange and it does not work.

I've attached the code for the complete macro (M1) and highlighted where it appears to go wrong.

Please Login or Register  to view this content.

Can anyone help me to see why it goes wrong?