Hi

I have designed a template for staff to use when they have entered the
data and close the workbook a copy is saved to a specified folder with
a name that has been pulled from specified cells. The code is as
follows:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True

    name_value = Cells(10, 2) & " " & Cells(11, 2)
       ActiveWorkbook.SaveCopyAs Filename:="C:\Documents and Settings
\fmgads1\My Documents\Training\" & name_value & ".xls"
End Sub

Is there some code that I can add to this so that the saved copy
doesn't have any macros.

Thanks
Andy