Up until yesterday, I was working with Excel 2010. Today I up graded to Excel 2016, but now one of my macros is not working properly.

The Macro's function is to copy data from 12 cells from one sheet to anotherone, and it's attached to a button. When I "click" on the button, only the first two pieces of information make it to the next sheet. The Macro continues to run, jumping from sheet to sheet, but leaving blank cells. The funny part is that this only happens when I run the Macro from the button, if I do it directly from the developer tab, it runs perfectly.

I all ready deleted the button and re-assigned the the macro to a new one, but it still doesn't work. I also reviewed the Macro on VBA, and there's no difference in the way the instructions are written for the first two items and the rest of them.

Any ideas as to what's going on and how to fix it?

Thanks