Microsoft KB Archive/133331

= OFF95: "Illegal Operation" Error Running Macro in Binder =

Article ID: 133331

Article Last Modified on 8/16/2005

-

APPLIES TO


 * Microsoft Office 95 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q133331



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.

When you click Close, you may also receive an illegal operation error message in Binder.



CAUSE
This problem occurs if the macro that you run returns the following error message in Microsoft Excel: Sub or Function not defined For example, if you create the following macro Sub Test msgbxo "test" End Sub (note the misspelled "MsgBox" command), when you run the macro in Microsoft Excel, you receive the "Sub or Function not defined" error message as expected. However, if you run this same macro from a Microsoft Excel worksheet section in a Binder, you receive the Illegal Operation error message.



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.

