How to copy a form button from one sheet to another using code

[orbatrin]

Hi,

I am trying to copy a form button from one excel sheet to another sheet while keeping everything intact including position of the button and macros associated to the button. **This NEEDS to work in Excel 2007**

my current code copies an entire sheet over to a new sheet including the buttons and this works perfectly fine using Excel 2010 and above but in Excel 2007, the button does not copy over. Looking for a solution to copy the form button over to another sheet using in Excel 2007.

I will post my code upon request but its not necessary as the code simply copies entire sheet contents from Sheet1 to Sheet2.

Please help.

 

[davesexcel]

What happens when you right click the sheet tab and select "Move or Copy.."?

 

[orbatrin]

What happens when you right click the sheet tab and select "Move or Copy.."?

Manually copying the sheet will copy everything over just fine. My template is constructed to copy sheet contents to another sheet using VBA, with that said, copying sheet contents to another sheet does not copy over the form button in excel 2007 but works fine in 2010+

Looking for a workaround other than the copy/move tabs.