My program has a macro that should normally be executed before the user
closes the file. The macro transfers data to a destination file, but there
are times where the user forgets or neglects to run it.

I would like to have a warning message display only when the user attempts
to close the file and the macro has not been run. I don't want to go as far
as forcing the macro as there are times when the file is opened and worked
on and then may be aborted for a legit reason.

Any suggestions?