Copying Push Buttons

Copper Contributor

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?

3 Replies

Hi @M Neil Cameron,

 

Try to right click the sheet and make copy of that.

 

Hi,

 

Try to paste that information as values only, or eliminate that buttons from the copy area before copy.

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.