When you've likely observed the distinction between this option and alternative #1 is the fact that, now, Excel notifies you that a macro continues to be disabled. Here is the default solution in Excel and, as spelled out in Excel 2013 VBA and Macros Within this dialog box, there are https://www.customguide.com/google-sheets/how-to-lock-cells-in-google-sheets