Forum Discussion
M Neil Cameron
Jul 13, 2017Copper Contributor
Copying Push Buttons
I have a sheet with multiple push buttons and when I copy the information to a new sheet additional buttons over and above the ones on the sheet are created. Can any one help?
Bill Benson
Sep 27, 2017Copper Contributor
It is controlled by this option in Excel.
Application.CopyObjectsWithCells = False
If that is set to false (It is also able to be set manually in Excel Advanced options, Cut, Copy and Paste it is the checkbox that says Cut, Copy and Sort objects with their parent cells.