RESOLVED[Deleting Vba code - Urgent]

[Fonty]

I have a user form which gives you in the end a report of the data you filled. This report is printed in a worksheet called Report. In this worksheet the is at the bottom a text box grouped with some image in a shape as backgroud. In this text box you enter the name of the report, and then, after a click on Save button you get the following code:

Private Sub cmdSave_Click()
 
Dim Dest As Workbook
 
    file= ThisWorkbook.Path & "\" & txtFile.Value & ".xls"
    Worksheets("Report").Copy
    Set Dest = ActiveWorkbook
    Dest.SaveAs file
' Here the Shape and the text box which where grouped are deleted, so that
' you only see the report
    ActiveSheet.Shapes("Group 1").Select
    Selection.Delete
    ActiveSheet.Range("A1").Select
    ActiveWorkbook.Save
    
End Sub

It works just fine. However, my question is, is it possible that once it is saved in the new location, the Vba code gets deleted, in order to have only an Excel sheet which will not ask you every time about the macro security?

[Ecniv]

Can't you create a new workbook and sheet, and put the report in there?

[RobDog888]

If you have VBA code behind the sheet object then that will get copied over too. You will need to copy the range on your sheet and paste it into the new blank sheet.