How to default Macros to run from This Workbook, NOT All Open Workbooks?

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” ?


Leave a Reply

Your email address will not be published. Required fields are marked *