Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins &
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
Function Setup instructions.
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
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
Create a new, empty
"module" in Visual Basic (Excel's macro language), into
which you will later copy & paste your power4XL
Open the Visual Basic
Editor: On the Excel menu, select Tools - Macro - Visual Basic
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
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
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
Individual Function Setup.
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.