Sub makebooks()


Set FrontEnd = Workbooks.Add(template:=xlWBATWorksheet)
Set FrontEndSht = FrontEnd.Sheets(1)

'create copy of worksheet in new workbook by using copy without before or
after
FrontEndSht.Copy
Set Newbk = ActiveWorkbook

Newbk.SaveAs Filename:="c:\temp\bookx.xls"

End Sub


"IT" wrote:

I want create two Excel file, one for fontend only for user type in data ,
after press save button in this form. The record can save data to backend
excel file for record. because i want protect backend file modify by user.
Please advice how can do that