"One of your object libraries is missing or damaged" error message when you open a file by using a VBA macro or when you try to start the Visual Basic Editor (296114)
The information in this article applies to:
- Microsoft Excel 2002, when used with:
- the operating system: Microsoft Windows NT 4.0
- the operating system: Microsoft Windows 2000
This article was previously published under Q296114 IMPORTANT: This article contains information about modifying the registry.
Before you modify the registry, make sure to back it up and make sure that you
understand how to restore the registry if a problem occurs. For information
about how to back up, restore, and edit the registry, click the following
article number to view the article in the Microsoft Knowledge Base: 256986 Description of the Microsoft Windows Registry
SYMPTOMS When you open a file with a Visual Basic for Applications
macro or you try to start the Visual Basic Editor, you may receive an error
message similar to one of the following: One of your
object libraries (excel9.olb) is missing or damaged. Please run setup to
install it. One of your object libraries
(stdole32.tlb) is missing or damaged. Please run setup to install it.
When you click OK in the dialog box for the first error, the following error
message appears: An error occurred initializing the VBA
libraries (32797). When you click OK in the dialog box for the second error, the following error
message appears: An error occurred initializing the VBA
libraries (32796). CAUSE The error messages described in the "Symptoms" section of
this article can appear if the permissions on the following registry subkey, or
one or more of its subkeys, has been changed from their default values:
HKEY_LOCAL_MACHINE\Software\Classes\TypeLib
RESOLUTION To resolve this problem reset the permissions to the
default settings by using the appropriate method for your version of
Windows. WARNING: If you use Registry Editor incorrectly, you may cause serious
problems that may require you to reinstall your operating system. Microsoft
cannot guarantee that you can solve problems that result from using Registry
Editor incorrectly. Use Registry Editor at your own risk. Windows NT 4.0 The default permissions on the
HKEY_LOCAL_MACHINE\Software\Classes\TypeLib subkey on Windows NT 4.0 are as
follows:
User/Group Permission
---------------------------------------------------------------------
Creator Owner Full Control
Everyone Read
<machine name>\Administrators Full Control
Interactive Special Access
System Full Control
NOTE: The Special Access permissions for the Interactive account
include the following:
Query Value
Set Value
Create Subkey
Enumerate Subkeys
Notify
Delete
Read Control
Change the permissions back to their default values. To do this,
follow these steps:
- Log in as a member of the Administrators group.
- On the Start menu, click Run.
- In the Open box, type Regedt32 and click OK.
- Under the HKEY_LOCAL_MACHINE key, locate and select the
following subkey:
- On the Security, menu click Permissions. If the Everyone group, is not listed in the Registry Key Permissions dialog box, add this group and assign it Read permissions. To do
this, follow these steps:
- In the Registry Key Permissions dialog box, click Add.
- In the Add Users and Groups dialog box in the List Names From list, select the machine name.
- In the Names list, select the Everyone group, and then click Add.
- In the Type of Access list, select Read.
- Click OK.
- Repeat steps a through e for each group for which you
need to reset permissions to their default settings.
- In the Registry Key Permissions dialog box, click to select the Replace Permission on
Existing Subkeys check box.
- Click OK.
- If you receive a message about replacing permissions on
all existing subkeys, click Yes.
- On the Registry menu, click Exit.
- Log off and then log back on as the user experiencing the
problem described in the "Symptoms" section of this article.
Windows 2000 The default permissions on the
HKEY_LOCAL_MACHINE\Software\Classes\TypeLib subkey on Windows 2000 are as
follows:
User/Group Permission
---------------------------------------------------------------------
Administrators (<machine name>\Administrators) Full Control
Creator Owner Full Control
Everyone Read
Power Users (<machine name>\Administrators) Special
System Full Control
Users Read
NOTE: The Special permissions for the Power Users group include the
following:
Query Value
Set Value
Create Subkey
Enumerate Subkeys
Notify
Delete
Read Control
Change the permissions back to their default values. To do this,
follow these steps:
- Log in as a member of the Administrators group.
- On the Start menu, click Run.
- In the Open box, type Regedt32 and click OK.
- Under the HKEY_LOCAL_MACHINE key, locate and select the
following subkey:
- On the Security menu, click Permissions.
If the Power Users group is not listed in the Permissions for Typelib dialog box, add this group and assign it Special permissions. To
do this, follow these steps:
- Click to clear the Allow inheritable
permissions from parent to propagate to this object check
box.
- In the Security dialog box, click Copy.
- Click Advanced.
- In the Access Control Settings for
TypeLib dialog box, click Add.
- In the Look in list, select the machine name for your computer. In the Name box, type Power Users. Click OK.
- In the Permission Entry for TypeLib
dialog box set the following permissions for the Power Users group.
Query Value
Set Value
Create Subkey
Enumerate Subkeys
Notify
Delete
Read Control
When finished, click OK. - In the Access Control Settings for
TypeLib dialog box, click to select the Reset permissions on
all child objects and enable propagation of inheritable permissions
check box.
- Click OK. If you receive a prompt about removing explicitly defined
permissions on all child objects, click Yes.
- Repeat steps a through h for each group for which you
need to reset permissions to their default settings.
- In the Permissions for TypeLib dialog box, click OK.
- On the Registry menu, click Exit.
- Log off and log back on as the user experiencing the
problem described in the "Symptoms" section of this article.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbstartprogram kbAutomation kbmacro kbopenfile kbdtacode kberrmsg kbprb KB296114 |
---|
|