Excel 2.20: DISABLE.INPUT() Does Not Function on Macintosh

Last reviewed: October 31, 1994
Article ID: Q48959

SUMMARY

The DISABLE.INPUT() function in Microsoft Excel for the Macintosh version 2.20 does not disable input from the Macintosh keyboard or from the Macintosh mouse. A macro error will result at the macro cell containing this function when the macro is run on the Macintosh. To prevent this error, use the following syntax:

   =ERROR(FALSE)
   =DISABLE.INPUT(TRUE)
   =ERROR(TRUE)

When an Excel 2.20 macro containing this function is transferred to Microsoft Excel for Windows, the function operates correctly.

KBCategory: kbother

KBSubcategory:
Additional reference words: 2.20

Microsoft KB Archive/48959

Excel 2.20: DISABLE.INPUT() Does Not Function on Macintosh

SUMMARY