On Exit Dialog Box

[Smurfit-Stone]

Hello Board,

I would like to have an dialog box pop up for users asking them if they have archived data in the worksheet before closing/exiting or saving. I've tried looking for something in the (This workbook) section of visual basic, but I can't find anything. Your help would be greatly appreciated. Thanks in advance

 

[MisterBate5]

In the Developer tab, choose Visual Basic. In the left-hand navigation pane, double-click "ThisWorkbook". In the right hand window, at top left, change "(General)" to "Workbook" - you'll get a Workbook_Open event generated. At top right, choose "BeforeClose" and then "BeforeSave". If you want your code to run before the workbook is closed and before the workbook is saved, create a subroutine and call it from both events. Note that "BeforeClose" will run if Excel is exited with your workbook open. Note also that Excel's default handling of open+modified workbooks will mean that you could end up asking the user twice, so plan to test a few scenarios.

 

[Smurfit-Stone]

Thanks Steve. I truly appreciate the help. It works great.