QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Enable Macros in Excel 2016?

By Neha T Leave a Comment

When you open an excel file that have macro or macros, a warning appears to enable macros in excel file. The macros are used to automate the tasks that the user needs to perform repeatedly. The macros are created by recording a sequence of commands over a cell in a file.

The macro once created, can be run over any cell/cells when you have to perform the desired task. Most of the macros are created by the software developers using VBA (Visual Basic for Applications).

By enabling the macros, you may risk your system. As enabling the macros of the file, from an unreliable source can introduce a virus into your system. So, remember, enable the macros, only if you know that the file is from the reliable source.

We will see four methods to enable macros in excel 2016:

  1. Message Bar
  2. Security Warning
  3. Enable for One Session
  4. Trust Centre

Steps to Enable Macros in Excel 2016:

Enable Macros Using Message Bar

Open a file containing macros, a yellow bar will appear at the beginning, with the shield icon. It has the message “SECURITY WARNING Macros have been disabled” along with the Enable Content button.

If you rely on the source of the file, then and want to enable the macros in it, click on the Enable Content button and start using the file.

enable macro in message bar

Enable Macros Using Security Warning

Note: This method allows the macros in the file to be always enabled.

First, click on the File tab of your excel workbook. In the backstage view you will see a yellow Security warning box as you can see in the picture below:

enable macro via security warning

Here, click the Enable Content drop-down box. Two option will list down ‘Enable All Content’ & ‘Advance Option’. Click on Enable All Content. Doing this you will allow the active content of the file to be always enabled.

Enable Macros for One Session

Note: This method of enabling the macros will enable the macros in the file, for the current session only. Once you close the workbook and reopen it again the security warning will reappear.

Step 1: Click on the File tab and at the backstage view in Security Warning yellow box, click the Enable Content dropdown button. Now, among the two options click on Advanced Options. .

enable macro for one time 1

Step 2: A dialog box “Microsoft office Security Options” will open. Here, select Enable content for this session. Click OK.

enable macro for one time 2

Enable Macros Using Trust Centre

Note: Changing the macro setting in Trust centre will reflect change only in the office program that you are currently using. It will not reflect the changes in all office programs on your computer.

Step 1: Click on the File tab and at the backstage view, click on the Options.

enable macro in trust centre

Step 2: Excel Options dialog box will open. Further click on Trust Centre.

enable macro in trust centre 1

Step 3: At the right side under Microsoft Excel Trust Centre, click on Trust Centre Settings… A Trust Centre dialog box will open.

enable macro in trust centre 2

Step 4: In the Trust Centre dialog box, at the left side click on Macro Settings. At the right side, under the Macro Settings section, click on Enable all macros. But doing this will put your system to risk in the context of viruses and malicious code. Click OK.

enable macro in trust centre 3

This is how you can enable macros in excel. Remember before enabling macros, be assured that the file is from the reliable source and it must not have a destructive macro in it.

You Might Also Like:

how-to-delete-macro-in-ms-excel-2016-featured-imageHow to Delete Macro in MS Excel 2016? How to create and execute Macros in MS WordHow to create and execute Macros in MS Word how-to-break-links-in-ms-excel-2016-featured-imageHow to break Links in MS Excel 2016? how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? how-to-transpose-in-ms-excel-2016-featured-imageHow to Transpose in MS Excel 2016? how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? Auto Fill in MS Excel 2016How to use Autofill in MS Excel 2016? how-to-create-macro-in-ms-excel-2016-featured-imageHow to Create Macros in MS Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Add or Remove programs in Ubuntu 14.04
  • How to Delete Macro in MS Excel 2016?
  • How to create a filter to sort emails and apply label in Gmail
  • How to Encrypt E-mail in Outlook 2010
  • How to Schedule a Meeting in MS Outlook 2016?

Copyright © 2023 · QueHow · Contact Us