I am free because I know that I alone am morally responsible for everything I do. For that reason, many users may find it desirable to disable macros by default. I've assumed pre-2007 based on the wording of post and the reference to You never know what terrors a Microsoft Office document from an unfamiliar sender might contain. If you need specific help with Excel 2007/2010 settings, let us know which version of Excel you are using. The equivalent macro security setting is available in both 2007/2010 also. If you are using Excel 2010, you can either put the workbook into a trusted location using the Trust Center settings, or declare it to be a trusted workbook.
If you are using Excel 2007, you could put your workbook into a trusted location using the Trust Center settings. Excel 365 says macros are disabled even though they ARE ENABLED.and will not open/run spreadsheet We're trying to run a spreadsheet with MACROS and VBA in the Office 365 version of Excel on WIndows v8.1. So you don't have to worry about changing it for all of your workbooks, one by one. This setting is applied to Excel, not a specific workbook. The changed setting does not take effect until you do this. IMPORTANT: After you change the setting and out of the dialogs, close Excel and re-open it. If you trust the source, choose otherwise choose disable. Macros greatly simplify the user's work, which also applies to the program in question. You choose or based on your trust of the source of the workbook.
Receive from an unknown source has macros in it and might be unsafe. I consider the one-extra-mouse-click worth the time to remind me that a workbook I might This is about the safest, most convenient (or least inconvenient) setting - it is the setting I use on my system, and darned near all my workbooks have macros in them.
This will alert you to the fact that there are macros in a workbook that has them and allow you to choose whether to Enable (allow to run) or (do notĪllow them to be used) the macros in that workbook. On the tab, I recommend choosing the Medium setting. You may have to expand the list at that point to allow you to see the option "Security" (it's in same list with Macros option). It sounds like you are using Excel 2003 or earlier?