OFF95: "Illegal Operation" Error Running Macro in Binder

The information in this article applies to:

• Microsoft Office for Windows 95, version 7.0
• Microsoft Excel for Windows 95, version 7.0

SUMMARY

In Office Binder, when you run a macro in a Microsoft Excel worksheet section, you may receive an Illegal Operation error message. If you click Details, information similar to the following appears:

   EXCEL caused an invalid page fault in module VBA32.DLL at
   0137:00b30d7d.

CAUSE

This problem occurs if the macro that you run returns the following error message in Microsoft Excel:

   Sub or Function not defined

   Sub Test()
      msgbxo "test"
   End Sub

WORKAROUND

To avoid this problem when you run a macro in a Microsoft Excel worksheet section in a Binder, run the macro first from within Microsoft Excel, before you run the macro in Office Binder. If the macro is already in a section in a Binder, click View Outside on the Section menu to view the macro in Microsoft Excel. You can then run the macro, and modify your code to correct any run-time errors or misspelled commands.

Note that the only way to view a module sheet in a Microsoft Excel worksheet section in a Binder is to view the Microsoft Excel worksheet section outside the Binder by clicking the View Outside command on the Section menu.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here as it becomes available.

REFERENCES

For more information about adding a document to a Binder, click the Index tab in Binder Help, type the following text

   Binder, adding