auto_close macro

[Guest]

how can i make a auto close macro so that it save all active workbook when closing down?

sub auto_closed
ActiveWorkbook.save
End Sub

i can only make it save 1 active workbook ;/

 

[dk]

You could try something like this:-

Sub Auto_Close()
Dim wb As Workbook

On Error Resume Next
For Each wb In Excel.Workbooks
    wb.Save
Next

End Sub

HTH,
D