It does copy the VBA,I tested it.

It doesn't copy the button, I assumed that would not be wanted so I deleted it.