Before Close Event problem

[Simmy]

Can anyone help

I have put code in my personal workbook that runs a macro when the workbook is opened(On_Open event)and one to clean up when it closes(Before_Close event). The open event works perfect every time but I have found that if I close Excel with the X button in the top right hand corner my Before_Close event does not run. Is there any way around this.

Grateful for any help

Simmy123

 

[Pcfred]

try using a sub called auto_close instead of the before close private sub.

Sub Auto_close()

'stuff to do goes here.

end sub

 

[RobBroekhuis]

Personal.xls must get special treatment from Excel (I duplicated your problem on my side). On the other hand, all my addins have beforeclose events that get handled just fine. So putting your code in an addin is another option. Pcfred's suggestion works just fine, though.
Rob

 

[Simmy]

Thanks guys

Will try auto close routine

Thanks again for your help & time

Simmy123