disable macros in excel on an open sheet

Because you selected 'Disable all macros with notification' in Step 4 above, you will need to follow Steps 8 and 9 each time you open a spreadsheet that contains macros (if you want the macros to run, that is).Īlternately, in Step 4 above, you could select 'Enable all macros.' This would allow any and all macros to run freely at all times. Select the radio box beside 'Enable this content,' then click 'OK.'Īfter you click 'OK' and the window closes, your macros should function normally. In any case, when you're ready to enable macros in your Excel program, you'll find that it's a snap.ĩ.

You always want to verify a spreadsheet macro's source, and make sure you trust the soul who created the thing. Macros can be huge time- and effort-savers, but because they could conceivably be programmed to do pretty much anything to the computer they're running on - say, wipe out the hard drive, or even something worse - we have to be very careful with the Excel macros we run. In my case, I often use macros to sort and/or clear out spreadsheet data (with a single click!) and to perform a variety of similar mundane duties. 'Macros,' where Excel is concerned, are simply sets of instructions that tell Excel to automate some process (or processes) inside the spreadsheet. Since I get a fair amount of readers downloading my financial spreadsheets and asking, 'How do I get the macros to work?' I decided to write a quick tutorial on just that topic.

Disable macros in excel on an open sheet