When you've likely found the distinction between this option and option #one is usually that, now, Excel notifies you that a macro has been disabled. This is the default solution in Excel and, as discussed in Excel 2013 VBA and Macros “Stability Hazard – Microsoft has blocked macros from functioning https://www.customguide.com/excel/find-and-replace-in-excel