power4XL Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins & More!

Displaying Developer Tab & Setting Macro Security

ShareThis

In order to access Visual Basic and other macro functions in Excel 2007 and later, you must first display the Developer tab in the Ribbon Interface.  The Developer Tab is hidden by default upon installation of Excel.

First confirm that the Developer Tab is not already activated.  If activated, the Developer Tab will be visible to the right of the View tab as highlighted below.

 

 

If the tab is not visible, then first click the Microsoft Office Button, then click Excel Options as illustrated below.

In the Excel Options dialogue box, select "Popular" in the left column, then select the box "Show Developer tab in the Ribbon" as illustrated below.

 

 

Finally, click "OK" at the bottom right of the Excel Options dialogue box to save your changes.  Now confirm that the Developer Tab is showing on the Ribbon.

Now enable macros in the Trust Center.  Open Excel Options again as described above, then select Trust Center from the left sidebar menu.  Then click the "Trust Center Settings..." button that appears in the right panel.  This will open the Trust Center window displayed below.  Click "Trust access to the VBA project object model".

 Now you have two options under Macro Settings above:

  • If you select "Disable all macros with notification", Excel will give a security alert (red circle below) each time you attempt to open a file containing macros.  In this case, you must click the "Options..." button on the alert bar, then select "Enable this content" from the security options dialogue.  Click OK, and the file should open with macros enabled.

  • If you select "Enable all macros" in the dialogue box above, you will not receive the security prompt below.  However, this may put your computer at risk to malicious code contained in other files.

 

Now you'll need to learn how to save files in the macro-enabled file format first introduced in Excel 2007.

 

Prev | Contents | Next

Copyright notice:  This site and all content, including computer code and spreadsheet examples, are copyright 2006 by Fritz Dooley.  License is granted for individual users to download examples and to copy code directly into user's spreadsheets and Visual Basic for Applications files.  Users may not redistribute code in any way.  Providing hyperlinks to this web site is encouraged, but posting code and examples on other web sites is expressly forbidden.  "Microsoft" is a registered trademark of Microsoft Corporation.   Neither this web site nor Fritz Dooley is affiliated with Microsoft Corporation.