Jul 13 2017
06:54 AM
- last edited on
Jul 25 2018
09:37 AM
by
TechCommunityAP
Jul 13 2017
06:54 AM
- last edited on
Jul 25 2018
09:37 AM
by
TechCommunityAP
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?
Jul 13 2017 08:11 PM
Jul 14 2017 05:26 AM
Hi,
Try to paste that information as values only, or eliminate that buttons from the copy area before copy.
Sep 27 2017 02:52 PM
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.