Resolving “This program has performed an illegal operation and will be shutdown” error

Let’s consider a real life scenario wherein when you start Visual Basic Editor in Microsoft Excel, you might receive the below-mentioned error message:
This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.

The above-mentioned error message may occur if the corresponding registry entry for Microsoft Visual Basic for Applications (VBA) is damaged.

In order to resolve the above-mentioned error, you need to delete the below-mentioned key in the Windows registry:

HKEY_CURRENT_USER\Software\Microsoft\VBA

The aforementioned registry key that you deleted is re-created the next time you start Visual Basic editor. In order to delete the aforementioned registry key, perform the following steps:

1.Quit Excel (if it is running).

2.Export the HKEY_CURRENT_USER\Software\Microsoft\VBA registry key to a .reg file. In order to export the registry key to a .reg file, perform the following steps:

a.Click Start -> Run.
b.In the Open box, type regedit.
c.Click the Ok button.
d.Find and then click the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\VBA
e.On the File menu, click Export.
f.In the File name box, type a name for the .reg file, specify a location where you want to save the file (for example, the Desktop), and then click the Save button.

Note: To undo the registry changes that you make in the next step, double-click this exported .reg file.

2.Delete the HKEY_CURRENT_USER\Software\Microsoft\VBA registry key. In order to delete the registry key, perform the following steps:

a.Right-click the HKEY_CURRENT_USER\Software\Microsoft\VBA key that you searched in step 2d, and then click the Delete button.
b.When prompted to confirm the deletion, click Yes.

2.Quit the Registry Editor.

In case you do not know how to start Visual Basic Editor in a Microsoft Excel 2000 program, follow the below-mentioned steps:

1.Start the Excel 2000 program.

2.Perform either of the following:
On the Tools menu, point to Macro, and then click Visual Basic Editor

-or-

Press ALT+F11.

By following the aforementioned solution, you should be able to resolve the error. However, in case you are unable to resolve the error, you can take help of a professional and efficient third party XLS repair tool to repair the damaged and corrupt Excel file.

A number of XLS repair tools are available in the market. Pay due care and attention to choose the XLS repair tool among the huge list of XLS repair tools. However, in case you are not able to make up your mind for an XLS repair tool, our suggestion to you is to download and experience working on the XLS repair tool. This would fetch you a fair idea about the various features, functionality of the tool. Moreover, you will be able to evaluate the tool’s performance with the help of the XLS repair tool.

Purchase the XLS repair tool, only when you are absolutely confident that the particular tool would be able to help you in repairing the damaged and corrupt Excel file.

Recoveryfix for Excel is one such professional XLS repair tool that has the ability to repair damaged and corrupt Excel file, corrupted due to any reason. With the help of Recoveryfix for Excel, you can easily, accurately, and flawlessly perform XLS repair.

The Author of this article is an engineer and product reviewer who has knack of new technology related to XLS Repair. He loves to work using different and new XLS repair tool and write reviews regarding the same.