VBA: ErrMsg: "Class Not Registered" Inserting UserForm

• Microsoft Excel 97 for Windows
• Microsoft PowerPoint 97 for Windows
• Microsoft Word 97 for Windows
• Microsoft Visual Basic for Applications version 5.0

SYMPTOMS

When you attempt to insert a UserForm while you are in the Microsoft Visual Basic Editor in one the products listed at the beginning of this article, or when you attempt to open a document that contains a UserForm, you may receive the following error message:

   Class not registered.
   Looking for object with CLSID:{AC9F2F90-E877-11CE-9F68-00AA00574A4F}

   The Help topic does not exist. Contact your application vendor for an
   updated Help file (129)

The error may also appear when you attempt to save a Microsoft Excel 97 document as an Hypertext Markup Language (HTML) document by clicking Save As HTML on the File menu. When you click OK, a dialog box with the following message appears:

   400

CAUSE

This problem may be caused by a missing or incorrect Microsoft Windows registry entry for the Dynamic Link Library Fm20.dll. The proper registration of this file is required when you work with UserForms and form controls in Microsoft Excel 97.

RESOLUTION

To resolve this problem, register Fm20.dll. You must have Regsvr32.exe to register Fm20.dll. If you do not have Regsvr32.exe you can download the file. For additional information, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q161983
   TITLE     : ACC: Regsv32a.exe Available on MSL

Registering Fm20.dll

To Register Fm20.dll, follow these steps:

1. Use Microsoft Windows Explorer to locate the Fm20.dll file in the Windows\System folder or in the Winnt\system32 folder (under Microsoft Windows NT).

   If the file is not present, copy it from the OS\System folder on the Microsoft Office 97 compact disc to the appropriate location.

2. Close all open programs.

3. Click Start on the Windows taskbar, click Run, and then type the following:

         Regsvr32.exe fm20.dll
   

4. Click OK. The following message should appear:

         DllRegisterServer in c:\windows\system\fm20.dll succeeded.
   

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.