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

See http://www.cpearson.com/excel/vbe.htm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
oups.com...
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