Hi, I’m trying to change the default setting on my macros ribbon button to “This Workbook” instead of “All Open Workbooks”? Specifically, when I press the Macros button in the developer tab, the box where I can select which Macro to run pops up. At the bottom of that box, there is a drop down box that’s titled “Macros in:” and then it gives the options to choose which workbooks I want to run the macros in (This Workbook, All Open Workbooks, etc). The current default is that the box has “All Open Workbooks” selected but I NEVER want my macros to run on all workbooks open. How do I change the settings so it defaults to “This Workbook” ?