Warning at Opening and Closing
An Excel file that teaches how to perform Warning at Opening and Closing operation.
Excel Warning at Opening and Closing
The workbook opening event is captured with VBA. Informative message boxes are shown to the user. The pre-closing approval question is triggered. A warning is generated for unsaved changes. Macros are run in accordance with security settings.
Hope it is useful.