Forum Discussion

M Neil Cameron's avatar
M Neil Cameron
Copper Contributor
Jul 13, 2017

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?

Macros & VBA
Need Help

3 Replies

  • Bill Benson's avatar
    Bill Benson
    Copper Contributor
    Sep 27, 2017

    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.

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jul 14, 2017

    Hi,

     

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