How to Enable or Disable Macros in MS Office 2010
While you are working on a Microsoft Office 2010 application, let’s say Excel or Word or Outlook, there can be several steps or actions that you may do on a document repeatedly. For example, you may mention the name of a person or a place or some particular calculation or any other action that you may repeat in the document. If you had to enter that information, each time you wanted it in the document, it could become very monotonous and boring. Also, it would be just a wasted effort to do it every time. To put an end to this, you could create a Macro and run it every time you need it.
However, this is just one side to this utility; there’s the other risky part to it as well.
As macro is a command to mechanize an action; you can share macro-enabled files with other users too – in your workplace or group. Similarly, you can receive such files too. In the guise of a legitimate document, cyber crooks or for that matter anyone with harmful intent can actually send you virus laden documents – the virus obviously piggy-backing a macro. This way, the dangerous macro can enter your computer and also your network.
How to reduce risks accompanying macros?
To ensure that risky macros aren’t able to do you any harm, you can disable them on a file which has been shared with you. It is a pretty simple task and you can do it by following the simple steps given below. Also, you can enable them anytime you need to automate an action on a document. For your easy understanding, we have highlighted the steps you can use in the different applications.
Enable or disable macros in Microsoft Office 2010 applications
There are two ways to enable or disable macro on a Microsoft Office 2010 document. Either you can do it from the Backstage View or you can enable or disable it from the Message bar.
If you are sure of the sender of a file with Macro enabled, you can look for the security warning (yellow strip in the Message bar) and press the button on it after selecting the Enable Content option. To disable it, reverse the action.
If you want to check out the option in the Microsoft Office Backstage view, click on the File tab let the Security Warning area pop up. Enable or Disable the macros in the document as per your choice.
If you are working on a particular project and for the ease of working on a document, your team members have created macros; you can let these macros run without you having to enable content each time by using the Trust Center options. To do it:
- Go to the File tab, select Options and then click on Trust Center followed by Trust Center Settings (small button on the bottom right side).
- Once the window will open up, select the option that best suits you.
Although, this will bypass the step in which you will have to allow macros every time you receive them, it will nonetheless also open doors to virus and malware. As per the option you selected, macros on your Microsoft Office 2010 will either be always enabled or disabled. So, be watchful of the file you are accessing on your computer with macro enabled.