How to Enable Macros in Excel 2007 in Windows 10

HOW TO ENABLE MACROS IN EXCEL 2010, 2013, 2016. With this article, the Basic Excel Online Blog will guide how to enable macros in Excel 2010-2013. You'll also see detailed instructions on how to disable macros or enable them via the Message bar and Backstage view . In addition, you will find tips for running macros even when all macros are disabled and creating a path that helps users pop them up in the worksheet.

HOW TO ENABLE MACROS IN EXCEL FROM THE MESSAGE BAR :
If you open an Excel file with macros, you will see a yellow message bar with a shield icon and an Enable Content button .

If you are sure the macro is from a reliable source, simply hit the Enable Content button in the bar.

HOW TO ENABLE MACROS IN EXCEL 2010, 2013, 2016

• IN EXCEL, ENABLE MACROS THROUGH BACKSTAGE VIEW :
  • HOW TO ALWAYS RUN MACROS FOR A RELIABLE SPREADSHEET:
  • ADJUST MACRO SETTINGS ON THE TRUST CENTER WINDOW .
  • RUN MACROS EVEN WHEN ALL MACROS ARE DISABLED:
  • HOW TO SAVE MACROS IN A WORKBOOK:
  • HOW TO DISABLE MACROS IN EXCEL 2010-2016:
  • USE SPECIAL CODE TO MAKE USERS TURN ON MACROS IN A WORKSHEET

IN EXCEL, ENABLE MACROS THROUGH BACKSTAGE  VIEW :

You can also enable macros in Excel by going throughBackstage view inMicrosoft Office . You can see a yellow Message  Bar if you click the File  tab .

1. Click the File  tab .

2. You will see a yellow Security Warning  area . Click Enable Content .

3. You will see 2 features: Enable All Content  and Advanced Options .Select Enable All Contentto open all the contents of the file.

Excel files are now considered trusted documents, and all macros will be enabled.

HOW TO ALWAYS RUN MACROS FOR A RELIABLE SPREADSHEET:

If you create and share files withmacros , you may want to avoid receiving security messages all the time. If you get all of your files from reliable sources, you can choose to run the macro immediately for all files. Here's how to enable all macros by default.

1. Go to File -> Options -> Trust Center  and click Trust Center Settings  … button.

Tip : You can also click the Trust Center Settings link  on Warning Security  .

2. You will see the Trust Center  window . Select Macro Settings  Options.

3. SelectEnable all macros (not recommended, malicious code can run).

From now on all macros will run without warning.

Please note that this installation makes your computer susceptible to virus infection. You should make sure that all files with macros are from a reliable source.

ADJUST MACRO SETTINGS ON THETRUST CENTER WINDOW .

You can find all the macro settings in theTrust Center window . These settings allow you to tailor the way you work with macro-enabled spreadsheets.

Follow the steps fromHow to always run macros for a trusted workbook to open the Trust Center  window .

Please see all explanations in the macro settings below:

• Disable all macros without notification  : Macros and security alerts related to them are disabled.
• Disable all macros with notification:  If you select this button, the macro will be disabled, but a security alert will appear if there are macros in the file. It allows you to enable macros in Excel depending on the data source.
• Disable all macros except digitally signed macros  : In this case, the macro is disabled, a security warning appears and is  digitally signed  using the macro running on the file of the trusted publisher. If you haven't trusted the publisher yet, you'll be prompted to activate the signed macro and choose to trust the publisher.
• Enable all macros (not recommended, potentially dangerous code can run) : All macros run without notice. Please note that this setting makes your computer susceptible to viruses.
• Trust access to the VBA project object model  : This option prohibits or allows program access to  Visual Basic for Applications (VBA)  from an automation client. This security setting is used to encrypt an Office program and manipulate the VBA environmentand object models. For automation clients to access the VBA object model, the user who runs the code must be granted access. You need to check the options for access.

RUN MACROS EVEN WHEN ALL MACROS ARE DISABLED:

Assuming Disable all macros without notification  is selected, but you need to run the macro right away. If you have Excel 2007-2013, you can turn on macros even if your security settings don't allow this. Excel places certain locations as trustworthy regions by itself. This means that if you save the files with macros there, you can skip the security check and run the macro.

Please see below list of reliable places:

Program Files \ Microsoft Office \ Templates

Program Files \ Microsoft Office \ Office12 \ Startup

Program Files \ Microsoft Office \ Office12 \ Library

Program Files \ Microsoft Office \ Office12 \ XLSTART

You can add any location on your computer to the trusted zone, by following the steps below:

1. In Excel go to theFile tab -> Options -> Trust Center -> Trust Center Settings -> Trusted Locations.

2. Click the Add new location  button to see the Trusted Location  dialog box of Microsoft Office  .

3. Click Browseto find the desired location on your computer.

Caution : Before adding any location to a trust, make sure that it is truly safe as that location can be attacked by hackers.

HOW TO SAVE MACROS IN A WORKBOOK:

Macros need you to save files in themacro-enabled workbook format . This style adds a security warning to your file. If you do not make the correct choice, the order will not be saved. Below you'll find how to save an Excel document that supports macros:

1. Navigate to File -> Save As  and choose the necessary location on your computer.
2. Click Save as type :arrow  and choose the Excel Macro-Enabled Workbook  from the drop-  down list.

3. 3. Click Save  to save the results.

If you forget to select the Macro Enabled Workbook  , you'll get a message that the macro won't be saved:

PressNo if you need to keep the macro.

HOW TO DISABLE MACROS IN EXCEL 2010-2016:

Suppose, you read only files and do not need to enable macros on your computer. You receive documents from a variety of sources and want your security settings to the highest level. Since some macros can be dangerous, you can disable all of them using the Trust Center  options .

1. Follow the steps fromHow to always run macros for a trusted workbook to open the Trust Center  window .
2. Select Disable all macros without notification   or Disable all macros with notification  . If you choose the first option, you won't know if there are any macros in the current file. The second option allows you to define an Excel workbook that contains macros.

USE SPECIAL CODE TO MAKE USERS TURN ON MACROS IN A WORKSHEET

This code hides all worksheets until the macro is activated. It also adds a table warning users to runmacros . As soon as the user turns on the commands, the warning panel is hidden and all other content is displayed.

1. Add the code to your spreadsheet.
2. Create a new table named "Alerts".
3. Add a message on the spreadsheet asking the user to reopen the workbook and turn on themacro .
4. Finally, save your spreadsheet.

VBA helps a lot in your work: it helps you speed up the processing in excel, helps to generate automatic reports, control other programs such as word, power point, outlook … to help turn your excel file back. into 1 professional software …

How to Enable Macros in Excel 2007 in Windows 10

Source: https://ngolongtech.net/how-to-enable-macros-in-excel-2010-2013-2016/

Share this post