Prompt for Action before closing workbook
Going to the well again.
I've recorded a data archiving macro. I would like to ensure that the User
doesn't forget to go through the archiving procedure before shutting down the
Workbook.
Is there a simple macro to prompt for an action before the user shuts down
the workbook (would assume this would work if they attempted to close Excel,
while the workbook was still open)?
Thanks again.
|