How to enable macros in Excel

Back to homepage

How to enable macros in Excel

If you are willing to accept the risk of enabling all macros in Excel, you can permanently enable them using the Trust Center.

  1. Click “File” and then click “Options.”
  2. In the Excel Options window, click “Trust Center” in the navigation pane on the left.
  3. Click “Trust Center Settings…”

Open the Trust Center Settings to tweak the way Excel deals with macros. Dave Johnson/Business Insider

  1. In the navigation pane on the left, click “Macro Settings.”
  2. In the Macro Settings section, click “Enable all macros (not recommended: potentially dangerous code can run)” and then click “OK.” As the option warns, this is a dangerous choice and not recommended.

This window is where you can turn macros on and off in Excel. Dave Johnson/Business Insider
If you want to disable macros in the future, return to the Trust Center and choose “Disable all macros with notifications.”
How to permanently enable a single macro in Excel
If you have an Excel file with a macro, you can easily enable it when you open the spreadsheet.

  1. Open the file with the macro in Excel.
  2. You should see a yellow Security Warning message bar advising you that macros have been disabled.
  3. Click “Enable Content.”

Click “Enable Content” to always allow this macro to run without being blocked. Dave Johnson/Business Insider
How to enable a macro in Excel for one time only
If you want to run a particular macro just one time, you can configure Excel’s security settings for that as well.

  1. Open the file with the macro in Excel.
  2. You should see a yellow Security Warning message bar advising you that macros have been disabled.
  3. Click “File” and then click “Info.”
  4. In the Security Warning section, click “Enable Content.”
  5. In the dropdown menu, click “Advanced Options.”

To enable a macro, click “Advanced Options” under the “Enable Content” dropdown. Dave Johnson/Business Insider

  1. Click “Enable content for this session” and then click “OK.”
    The macro will be enabled for this one time and will be disabled the next time you open the file.

MSSQL ‘Recovery Pending’ Problem

To solve MSSQL Recovery Pending problem follow the steps Stop SQL Remove transaction log on this database Change database mode to emergency mode and restart database After restart run this commands for your database ALTER DATABASE [DB_Name] SET EMERGENCY; DBCC checkdb...

Uninstall Edge from Windows 10

To uninstall Microsoft Edge from Windows 10 Close the Edge browser on your computer.Open the file explorer. You can easily do this by right clicking the Windows start button and then selecting File Explorer.In the file explorer, select This PC.Once in this PC navigate...

High Performance is not shown on PowerSetting

Right click StartSelect RunType regedit and press enter to open the registry editorGo to the folder: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\PowerOn the right, check one of the keys called CsEnabledClick on that keyChange the value from 1 to 0Restart your...

Convert an MBR disk into a GPT disk

Converting using the Windows interface Back up or move the data on the basic MBR disk you want to convert into a GPT disk.If the disk contains any partitions or volumes, right-click each and then click Delete Partition or Delete Volume.Right-click the...

MacBook Virtual Keyboard solution for broken touchbars

The solution was in Karabiner. Download Karabiner. Downloaded the "Map fn + number keys to their corresponding function keys" plugin If you need help you can reach us free online remote support over Anydesk.

Prevent deleting Google Chrome history

It is absolutely possible in windows. You can do it by adding a policy to the chrome browser using Registry Editor. Click the Windows button and search for Registry EditorRight-click on it and select Run as administrator.Navigate to HKEY_LOCAL_MACHINE >...

Lenovo 13 Thinkpad series camera freezes after 2 sec

Its realy big problem for Lenovo, when you started the camera, it freeze 2-3 seconds later. Thats the solve 🙂 Press Windows key + R, type regedit, and press Enter.Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Media Foundation\Platform.Right-click on the...

Print non-white colors in your PDF file as only black

On Windows, you can print all of the non-white colors in your PDF file as black, resulting in a simple monochrome printout. Printing as black is useful for printing PDFs that contain text only, or for printing engineering drawings that have lightly colored lines....

Change default browser page Edge to Explorer

Open Microsoft Edge browserGo to SettingsSelect Default browser tab optionin the internet Explorer compatibility setting, you will see an option "Let Internet Explorer open sites in Microsoft Edge" , the default value is Incompatible Sites only(Recommended). You can...

Mac SMC reset

Just hold down Shift+Option+Control when the laptop is off for 7 seconds. It will turn on. After 7 seconds keep holding the keys down and additionally press the power button (Touch ID). The laptop will turn off. Wait a few seconds then turn it on normally, and your...