Sorry can't help you there about appropriate or best

As I only have the basics, it's just how I do it and it works so I keep
doing it

"sugargenius" wrote in message
ups.com...
I'd already put it in Workbook_BeforeClose, and that fixed the problem.
Is Auto_Close more appropriate?