VBA to break links when copying tab to new workbook

Hi everyone,
I have an Excel 2013 workbook that I use a click button with VBA to copy and save the tab to a new workbook and it copies only the values as it should but...it also copies the button that is used in the original tab and keeps the link to that VBA. I would like to eliminate that button and link automatically within the original VBA. Is it possible to add something to this VBA or modify it so that the button with the VBA on the original page does not copy to the new workbook or at least remove the link to the VBA? Removing the button automatically would be nice but just removing the link automatically would be good enough. I am kinda new to this.
This is the VBA that I use to copy the tab to the new workbook by clicking the button on the original page:

Please Login or Register  to view this content.

Thanks for any help,
Foos Master
"Foosball is Therapy"

I would suggest that you create a temporary sheet within the source workbook. Then copy and paste the values and formats from the source sheet to the temporary sheet ... and maybe autofit the columns. Then move the temporary worksheet to the new workbook (not copy).

Theoretically, that should give you a new workbook with one sheet with the values and formats but no button(s).


Regards, TMS