Excel won't copy macro buttons along with sheet.

[Patrick1981]

Hp laptop with Windows 10 & Microsoft 365.
Just recently when I copy a tab in excel everything copies except the macro buttons.
It doesn't do it on older spreadsheets just newer one.
I went into options/Trust Cent/trust Center Settings/macro and enabled along with ActiveX, enable all.
Still wont copy macro buttons. I can manually copy them and paste them on the sheet, but them don't copy along with the sheet.
Any help would be appreciated.
Thanks

[#2 · Accepted solution]

@Patrick1981 

Found the problem.

In Excel Options - Advanced - Cut, copy, and paste - the Cut, Copy, and Sort inserted objects with their parent cells was unchecked.

Not sure how that happened, but it's fixed now.