Macro to fire when Closing File

I currently have a workbook saving an archive every time the file opens. The name of the macro is:

Please Login or Register  to view this content.

It's pasted in the Thisworkbook VBA tab and it works perfectly.

I thought I could change it to fire when closing by changing it to:

Please Login or Register  to view this content.

But it doesnt seem to be working. Why not?

I have an older version of Excel and never heard of Workbook_Close

Maybe:

Please Login or Register  to view this content.

Yeah, this should do:

Please Login or Register  to view this content.

Thank you!