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

Setting Macro Security in Excel 2003 (and earlier)


To enable macros in Excel 2003 and earlier versions, select "Security" from the "Tools - Macro" drop-down menu as illustrated below.

This will open the Security dialogue box shown below.  By default, security will be set to High. 


Now you have two options:

  • You can set security to Medium.  This will require you to select "Enable Macros" in the dialogue box below, which will appear each time you attempt to open a file containing macros.

  • Alternatively, you can select "Low" in the Security dialogue box above.  This will not require you to enable macros each time you open a file containing them, but may expose you to malicious code contained in files you obtain from other sources.

Now we'll install the Analysis ToolPak, open the Visual Basic Editor, and get to work.


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.