Microsoft KB Archive/109422

From BetaArchive Wiki

XL5: Formatting Dialog Frame When Sheet Protected Hangs Excel



The information in this article applies to:


  • Microsoft Excel for Windows, version 5.0





SUMMARY

In Microsoft Excel version 5.0 for Windows, if you choose Object from the Format menu and if the following three conditions are true


  • The dialog frame is not locked,
  • The dialog frame is the currently selected object,
  • The dialog sheet is protected,

Microsoft Excel will hang and you will receive the following error message:

Application Error
integer divide by 0



WORKAROUND

If your dialog sheet is protected, and if the dialog frame is the currently selected object, do not choose Object from the Format menu.

Note that you can format other objects in the dialog sheet even if the dialog sheet is protected.



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 for Windows 95, version 7.0.

Additional query words: crash hang stop responding quit

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :


Last Reviewed: April 12, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.