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

First Time Setup - Excel 2003

You will need to perform these steps only one time, prior to installing your first power4XL function.  After that you can install as many functions as you like without having to repeat these steps.

If you have already performed these steps, you can proceed to the Individual Function Setup instructions.

  1. Set your Microsoft Excel security settings to enable macros 
    On the menu, select Tools - Macro - Security.  Then set the Security Level to "Medium" or "Low" and click "OK".  We recommend Medium.
  2. Install the Analysis ToolPak Add-In that comes with Excel 
    On the Excel menu, select Tools - Add-Ins.  In the list of available add-ins, make sure the box next to "Analysis ToolPak" is checked, then click "OK".  Depending on how your Excel was originally installed, you may be required to insert your Microsoft Office Setup CD ROM for this process to be completed.  You may also have to exit Excel and restart it in order for the change to take effect.
  3. Create a new, empty "module" in Visual Basic (Excel's macro language), into which you will later copy & paste your power4XL functions.
  • Open the Visual Basic Editor:  On the Excel menu, select Tools - Macro - Visual Basic Editor.
     

  • Along the left side of the Microsoft Visual Basic window, the Project Explorer should be visible.  If not, press CTRL+R or select View - Project Explorer from the menu bar to display it.

  • Click on "VBAProject (PERSONAL.XLS)" in the Project Explorer window to select (highlight) it.

  • On the Visual Basic menu bar, select Insert - Module.  This will cause a new module to appear in the Project Explorer window under the VBAProject (PERSONAL.XLS) project.  The new module will be named "Module1" or "Module2", etc., depending on what modules already exist in your PERSONAL.XLS file.

  • To help you find your power4XL function module more easily in the future, rename "Module#" to "power4XL" as follows. 

  • First, make sure the Properties Window is visible by pressing F4, or by selecting "View - Properties Window" from the menu bar.

  • In the Project Explorer, click on your new module (name Module1 or Module2, etc.) to select it.  The name of that module should now appear in the Properties Window.

  • In the Properties Window (NOT the Project Explorer), double click on the name of your new module where it appears next to the word "(Name)".  This will select it for renaming.

  • Overtype the old name of your module with "power4XL".

  • Now your Excel program is set up and ready to receive power4XL macros and functions.

  1. Proceed to Individual Function Setup.

 

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.