View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EJ EJ is offline
external usenet poster
 
Posts: 20
Default Can I run a message box Macro on Save in Excel?

I want to remind users of a workbook that they need to fill in a last updated
cell if they have made any amendments to the sheet.

Is there a way I can get a message to pop up when they go to save the
document so they have to input the 'Last Updated' date in the relevant column
before they save and exit. And if I'm feeling really evil, can I get it to
not allow them to exit unless they've done it?

ps I'm a total VBA novice!