I need to run a macro when an end user closes excel by the red cross.

I'm currently using: Workbook_BeforeClose(Cancel As Boolean)
This works fine when they close just the workbook.

(I also have a "close and change settings" button they should press)

Why do I need this? I am changing the settings from manual to automatic.

Thanks in advance,