If you're still having this issue, go to the office button at the upper left
corner of the Excel program window.
Click on the "Excel Options" button at the bottom of that pop-up. It will
then open another window. Look for "Trust Center" at the left side. Click on
that, and work your way through that.
You'll then look for "Trust Center Settings."
Click on that, and you'll find where you can disable, or enable your macros
to work in all, or only certain workbooks.
This should resolve your problems.