4.1.2  Trusting Access to Visual Basic Project

If you are using Microsoft Excel 2002 or 2003 you may encounter difficulties checking the Trust access to Visual Basic Project checkbox in the Security Dialogbox (see also: Changing Security Settings). In some cases, the latter checkbox is grayed out on the Trusted Sources page (which is not the case in the example below). However, this checkbox always should be checked, otherwise you cannot startup and run ArArCALC. To make this checkbox active again, you should follow the instructions below:

• Go to the Windows Start button and select the Run ... tool.
• Type in regedit and hit OK to open the Registry Editor program.

• In the Registry Editor perform a Find for AccessVBom.

• If a key is returned, check to see if its part of SOFTWARE\Microsoft\Office\11.0\Excel\Security path, or any other variation on this path name based on different Excel versions (9.0, 10.0 or 11.0). If that is not the case, keep searching by clicking the Find Next button, until you find a match.

• If you found the correct Excel AccessVBom registry key, you should delete it by Right-Clicking on the item or via the Edit menu. You will be asked to confirm the deletion.
• Close the Registry Editor and try to set the Security Settings again.

See also ...

Contents	ArArCALC
Chapter 4	Miscellaneous Tips and Bug Fixes
Topic 4.1.1	Changing Security Settings
Topic 4.1.3	Installing Microsoft Office with Web Components
Topic 4.1.4	Adding Office Web Components (OWC) after the Microsoft Office Installation
Topic 4.1.5	How to Insert Symbols in Microsoft Excel

	First  |  Previous  |  Next  |  Last