Just like in Excel 2003 the user must tell Excel 2007 that the com holds UDF's before the functions inside VLXE can be called.
The steps are given below including screen dumps
1. Start Excel 2007
2. Click on the office Button which is marked with the red circle in the left corner.
3. After clicking on the office button, click on the "Excel options" button.
4. Select Add-Ins on the list to the left and click "Go"
5. Click on Automation
6. Scroll down on the list and select VLXE.Functions. Then Click "Ok".
7. When a pop-up shows, which says: "Cannot find add-in mscoree.dll. Delete from list?". Then click No
8. Click Ok and make sure the VLXE. Functions is checked
The functions in the add-in are ready for use.
Check by clicking on "Fx" to check that the VLXE functions are available:
