Sub BUandSave2()

[Mark]

how can i adapt the following macro to run when you exit
the workbook instead of when i save.

Sub BUandSave2()
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs
Filename:="T:\Invoices\Batch Book" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub


thanks

mark

 

[Guest]

hi,
Put the code in the on close event of the thisWorkbook
module.

 

[mark]

cheers

-----Original Message-----
hi,
Put the code in the on close event of the thisWorkbook
module.

.