I have a strange error 400 and do not know from where come from.
Someone has an idea about it?
Ina
--
Regards,
Tom Ogilvy
Ina
Sub SaveAsWithoutCode()
Dim VBComp As VBIDE.VBComponent
Dim VBComps As VBIDE.VBComponents
Set VBComps = ActiveWorkbook.VBProject.VBComponents
For Each VBComp In VBComps
Select Case VBComp.Type
Case vbext_ct_StdModule, vbext_ct_MSForm, _
vbext_ct_ClassModule
VBComps.Remove VBComp
Case Else
With VBComp.CodeModule
.DeleteLines 1, .CountOfLines
End With
End Select
Next VBComp
End Sub
and I placed it normally here in the workbook_open:
Public Sub Save_Exit()
SaveAsWithoutCode
Application.Quit
ThisWorkbook.Close SaveChanges:=True
End Sub