Copy sheet to new workbook but not the Macro buttons

[rpinxt]

Hi Guys,
I know there are several ways for this but there is some other parameter in play.

So I copy 2 sheets from a workbook to a new workbook.
On these 2 sheets there are "buttons" which trigger a macro.
I do not want these buttons to be copied/saved.

However the sheets also contain a pivot with pivot chart and the other sheet a chart.
Now the ways I found tend to also delete the chart and/or the pivotchart!

Of course that is something I do not want.
What would be the right way? So only the macro buttons but not the charts?
Thanks.

[Richard Buttrey]

Hi,

After the .Copy instruction use code like the following

Please Login or Register  to view this content.

[rpinxt]

Thanks this was indeed what I needed