Forum Discussion
Excel won't copy macro buttons along with sheet.
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
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.
1 Reply
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.