Add a workbook property that we can set at design time to force user to enable macros
If a workbook is reliant on macros or user-defined functions, developers often want to force the user to enable macros when they open that workbook. Current practice is to hide every worksheet except one displaying a nag to enable macros. We then use a WorkbookBeforeSave and WorkbookAfterSave event macro to do the hiding and unhiding of worksheets to make sure the nag message is displayed only when desired.
If we had a property we could set at design time to force the user to enable macros--or else the workbook wouldn't open, we would eliminate almost all the use cases for WorkbookBeforeSave and WorkbookAfterSave.
Note that even if the user is forced to enable macros to open the workbook, we need to retain the ability to prevent WorkbookOpen and AutoOpen macros from running (such as by holding the Shift key down when opening the workbook) in case there is a bug in those subs.