Buttons won't copy to a new sheet

[jvanderweerdt]

I have an Excel spreadsheet that has been used for years. I have used the following line of code to copy a sheet but it no longer copies the buttons:
ActiveSheet.Copy before:=Worksheets("CDS")

Any ideas?

Thanks for the help.

Josh

 

[SkipVought]

Hi,

What version of WindowS OS? Maybe 8?

Exactly what kind of buttons? Maybe ActiveX?

 

[jvanderweerdt]

The OS is Windows 7 and Excel 2010.

The button is a form control button, not ActiveX.

Josh

 

[combo]

Are you copying sheet to other workbook? If so, check settings of visibility of drawing objects in destination workbook.

combo

 

[jvanderweerdt]

No, the copied sheet is staying the same workbook.

Josh