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


285 thoughts on “How to default Macros to run from This Workbook, NOT All Open Workbooks?

  1. Reductil bestellen

    This design is incredible! You certainly know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Excellent job. I really loved what you had to say, and more than that, how you presented it. Too cool!

  2. Comprare Melanotan 2

    Hi there, just became alert to your blog through Google, and found that it is really informative. I’m going to watch out for brussels. I’ll be grateful if you continue this in future. A lot of people will be benefited from your writing. Cheers!

  3. anabole steroide kaufen

    I don’t even know how I finished up right here, however I believed this post used to be great. I don’t recognise who you’re however certainly you’re going to a well-known blogger if you aren’t already 😉 Cheers!

  4. Ephedrine T-5 Online Bestellen

    Yesterday, while I was at work, my sister stole my apple ipad and tested to see if it can survive a thirty foot drop, just so she can be a youtube sensation. My apple ipad is now broken and she has 83 views. I know this is entirely off topic but I had to share it with someone!

Comments are closed.