Save a file without Macro in it

  • Thread starter Thread starter michelle_ho
  • Start date Start date
M

michelle_ho

There is an excel file call A.xls. It is running Macro. I have created
form, there is a button which call "Save as" button. So when the butto
is click, it will be saved as another file. But I want to remove th
macro of the new file. How can i do so?

Here is the code of the "Save as" button:

Private Sub CommandButton3_Click()

Dim fName2 As String
fName2 = Application.GetSaveAsFilename("new_quotation.xls")
ActiveWorkbook.SaveAs Filename:=fName2, FileFormat:=xlNormal

End Su
 
Easiest would be just to copy the appropriate worksheets to a new file and
save that.

If you have code in the worksheets, then you would create a new workbook and
copy the cells to the workbook rather than the sheets.
 
Back
Top