NOTE: If the user doesn't have a shortcut for running the macros on Excel or something like that, You might have to enable the Developer tab on Customize the Ribbon. It is not a good idea to trust the entire C: drive or the Downloads folder, for example. Be careful which locations you set as trusted. Warning: When you set a directory as a trusted location, it removes all security checks from files in that location for all of Office.
You will want to choose a safe and isolated folder so that malicious macros won't be accidently moved into the folder.
Choose a folder where you needs to run your macros from.Check “Allow Trusted Locations on my network”.Go to: File > Options > Trust Center > Trust Center Settings > Trusted Locations.Launch the Office application (Microsoft Word, Microsoft Excel, Microsoft Access, etc.).
#Excel auto enable macros how to#
The following steps will show you how to create a trusted location to run macros from. Macros are automatically disabled on some university machines, due to exploitative ransomware such as "Locky", but they can still be manually enabled. You may require the use of legitimate macros (often unsigned) when working with Microsoft Excel, Word, Access, or other office applications. How do I enable unsigned macros in MS Office?.