While you've in all probability found the difference between this feature and possibility #1 is, now, Excel notifies you that a macro has become disabled. This is the default option in Excel and, as discussed in Excel 2013 VBA and Macros “Safety Threat – Microsoft has blocked macros from managing https://www.customguide.com/excel/how-to-freeze-a-row-in-excel