XL5: Incorrect Results/GP Fault Double-Clicking Toolbar Area

• Microsoft Excel for Windows, version 5.0

SYMPTOMS

In Microsoft Excel, if you use the OnDoubleClick property in a Visual Basic procedure, or the ON.DOUBLECLICK function in a version 4.0 macro to assign a macro to run when you double-click on a worksheet or chart, one of the following occurs when you double-click on the toolbars area:

• The macro that you assigned is run

  -or-

• You receive a general protection (GP) fault

CAUSE

This behavior occurs when you use the following in a Visual Basic procedure

   Workbooks("BOOK1.XLS).Worksheets("Sheet1").OnDoubleClick = "Test"

   =ON.DOUBLECLICK("[Book1]Sheet1", "Macro1!Test")

If BOOK1.XLS is open when you double-click on the toolbars area, the macro TEST runs. If you close BOOK1.XLS, and then double-click on the toolbars area in the same session of Microsoft Excel, you receive a GP fault.

WORKAROUNDS

To avoid receiving a GP fault, when you have used either the OnDoubleClick property or the ON.DOUBLECLICK function in the current session of Microsoft Excel, do not double-click on the toolbars area. Instead, do either of the following:

• From the View menu, choose the Toolbars command to display the Toolbars dialog box.

  -or-

• Close Microsoft Excel.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0c.

MORE INFORMATION

You can use the OnDoubleClick property or the ON.DOUBLECLICK function to set the name of a macro to run whenever you double-click anywhere on the specified chart or sheet. When you run the procedure that contains this property, or the macro that contains this function, the assigned macro should not run when you double-click in the toolbar area. Instead, the toolbars dialog box should be displayed.

REFERENCES

For more information about the OnDoubleClick Property, choose the Search button in the Visual Basic Reference and type:

   OnDoubleClick Property

   ON.DOUBLECLICK function