While you've in all probability seen the difference between this selection and choice #1 is always that, now, Excel notifies you that a macro is disabled. Here is the default solution in Excel and, as spelled out in Excel 2013 VBA and Macros Whenever you halt dragging, the selected spot https://www.customguide.com/excel/how-to-enable-macros-in-excel