As you've possibly discovered the difference between this feature and choice #1 is always that, now, Excel notifies you that a macro has become disabled. This can be the default option in Excel and, as spelled out in Excel 2013 VBA and Macros Notes: Likely Problems Check that all data https://www.customguide.com/excel/absolute-reference-excel