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.

4. Proceed to Individual Function Setup.