But this does not really resolve the problem, because sometimes it is necessary to add a password to the Workbook. If you remove the password, the Workbook will not display this message, and you will be able to run the Macro. What it means encrypted is that the Workbook contains a Macro and the Workbook is password protected. In fact, this message does say something about the reason for this alert, it explained that this error is caused by encrypted Macro.

If you click on the Options button, you will see the below message. This Excel Security Warning is one of the most annoying warnings in Excel. Excel Security Warning – Macros have been disabled We hope this article will help you to enable or disable macros in Excel.This Excel tutorial explains how to solve the problem of Excel Security Warning – Macros have been disabled.

If you don’t want grant access uncheck the check box. This Check box will be available under Macro Settings to enable all the VBA project models as most of the developers will use VBA to create Macros. Another available setting which is Trust access to the VBA project object model. Using these options you can modify your Macro options in Excel.

Just verify while enabling a macro as it may contain unwanted programs that may disturb your PC. Enable all macros This option will enable all the available macros.Disable all macros except digitally signed macros Click this option if you want disable all the macros except signed or certified macros.Disable all macros with notification Click this option if you want get notified while disabling and modifying the macros.It will disable all macros and embedded documents in sheet. Disable all macros without notification if you don’t trust macros Click on this option.It will open the Macro Settings window, here you can edit the settings.Go to Developer tab and Click on Macro Scurity.Another alternative method to modify Macro options is using Macro Security.Here you can enable or disable macros by selecting on respective radio button.In Trust Center windows find and Select Macro Settings.Now Click on Trust center Settings button.Click on File in the Menu bar and open Options window.Available Macro Options: Enable or Disable Macros in Excel:

Disable macros in excel 2016