Compile Error:

When you press the “Retirement” button on the command button, the Microsoft Visual Basic window opens and this message appears. 

This may be due to the missing dll files in your computer. ( The error message may be different than what is shown above) .

Solution:

1. If the Visual Basic Page is showing: Close the Microsoft Visual Basic Page by pressing the “X” on the top right hand corner.

This message will appear:

Click OK.

2. Press Alt F11 to open the Visual Basic Editor.

3. On the command menu, click on “Tools” and then click on “References”. The following dialog box will open:

4. Uncheck all boxes next to the line (or lines, if more than one) starting with “MISSING:…”. It does not matter what follows "MISSING", just uncheck them all. 

5. Click OK.

6. On the command menu, click on “Debug”, then “Compile VBA Project”

7. Save file by clicking on the “Save” icon

7. Close the Microsoft Visual Basic Page by pressing the “X” on the top right hand corner.

8. Now close Excel (without saving files) and restart The Otar Retirement Calculator.

 This should solve this problem. You only need to do this once after installation.