View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bman342 bman342 is offline
external usenet poster
 
Posts: 22
Default 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.