As you've possibly observed the distinction between this feature and possibility #1 is usually that, now, Excel notifies you that a macro has long been disabled. This is the default solution in Excel and, as discussed in Excel 2013 VBA and Macros Accessibility center Communities help you question and response https://www.customguide.com/excel/how-to-lock-cells-in-excel