How to remove vba (macro) button from newly saved excel sheet by vba codes?

[SIARAM]

Friends I have added a ‘Button 1’ to save as the file at another location by vba codes. It saves the file at required location but it shows the same ‘Button 1’ there also at the new saved file. I want it should not show this button in the new saved file. For example I created an excel sheet whose name is abc.xlsx and now this sheet is saved at m:\formats\xyz.xlsx by vba codes which are assigned to the ‘Button 1’ in sheet abc.xlsx. Now the same button i.e. ‘Button 1’ is shown in xyz.xlsx, but I want it should not be shown there. It should remain in the master file which is abc.xlsx. Kindly tell me what modifications I have to make in the codes. My codes are following-

Sub sb_Copy_Save_ActiveSheet_As_Workbook()        Set wb = Workbooks.Add
    ThisWorkbook.Activate
    ActiveSheet.Copy Before:=wb.Sheets(1)
    wb.Activate     wb.SaveAs "C:\temp\test3.xlsx"End Sub

 

[mumps]

Maybe:

Sub sb_Copy_Save_ActiveSheet_As_Workbook()
    Set wb = Workbooks.Add
    ThisWorkbook.Activate
    ActiveSheet.Copy Before:=wb.Sheets(1)
    wb.Activate
    ws.Shapes("CommandButton1").Delete
    wb.SaveAs "C:\temp\test3.xlsx"
End Sub