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

Setting up Excel to work with VBA macros

ShareThis

Excel has built-in security features to protect users from running harmful code.  These features are turned on by default when Excel is first installed.

Excel 2007 introduced a new user interface for navigating through the program, and additional hurdles for running macros, so the set-up for Excel 2007 (and following, hopefully) differs somewhat from Excel 2003 and earlier.

The basic steps for each are outlined below, with links to pages containing more detailed step-by-step instructions.

Excel 2007 Macro Setup

Excel 2003 (and earlier) Macro Setup

Once you have enabled macro execution, you will need to open the Visual Basic editor where you'll enter the VBA code.  If you're already familiar with this process, you can skip directly to the Simple Coin Toss example.

 

 

Prev | Contents | Excel 2007 | Excel 2003 | Skip to Simple Coin Toss

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.