Easy steps to change macro security settings in Microsoft® Excel 2010

Since you extensively work on Microsoft Excel 2010, you are probably required to perform the same tasks repeatedly. By tasks we mean formatting tasks. To do them, if you opt for the manual way, the tasks will surely become monotonous, boring, and time consuming. However, if you want to save yourself from the hassles of repeatedly doing the same thing over and over again, you could opt to set a ‘Macro’. A macro is used to create records of clicks and keystrokes, to run them later, in the exact sequence that you used the clicks and keystrokes. Therefore, it surely is a very useful tool that helps to increase your productivity. You can edit a macro, enable or disable it, or even change the macro settings in Microsoft Excel 2010.

Why would you need to change a macro setting?

A macro can sometimes pose itself as a security threat. If a harmful macro is created on a file, it can spread malicious virus and other threats on your computer and can even extend to other computers while you share files with them. To prevent this you may choose to set the macro security settings at High. While this will take care of all potential virus invasions on your computer, it will also disable all macros irrespective of whether a file has been sent from a trusted source. In situations like these, you may wish to change the macro security settings in your Microsoft Excel 2010 application.

Changing the macro settings in Microsoft Excel 2010 involves a simple process. You can do it in just few steps:

1. Go to the ‘File’ tab and then select ‘Options’.
2. Click on the ‘Customize Ribbon’ category.
3. Go to the ‘Main Tabs’ list and locate the ‘Developer’ check box and select it.
4. Click on ‘Ok’ and return to your file.
5. In the ‘Developer’ tab, click on the ‘Macro Security’ option.
6. Once you will have the list of options in front of you, you can click the one that suits your requirements (Microsoft Excel 2010 offers a choice of five different settings – Disable all macros without notification, Disable all macros with notification, Disable all macros except digitally signed macros, Enable all macros, and Trust access to the VBA project object model)