XL97: MS Excel Hangs When You Programmatically Save a WorkbookLast reviewed: February 27, 1998Article ID: Q143452 |
The information in this article applies to:
SYMPTOMSWhen you save a workbook in Microsoft Excel 97, the program may appear to stop responding (hang), and the following symptoms may occur:
CAUSEThis problem occurs when all of the following conditions are true:
RESOLUTIONTo prevent this problem from occurring, add the following code to all macros that you specify in the OnSave command:
Application.ScreenUpdating = Truebefore the end of each macro. NOTE: When this behavior occurs, you must quit Microsoft Excel by pressing ALT+F4.
STATUSMicrosoft 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 in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATIONMicrosoft provides examples of Visual Basic for Applications procedures for illustration only, without warranty either expressed or implied, including, but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures in this article are provided 'as is' and Microsoft does not guarantee that they can be used in all situations. While Microsoft support engineers can help explain the functionality of a particular macro, they will not modify these examples to provide added functionality, nor will they help you construct macros to meet your specific needs. If you have limited programming experience, you may want to consult one of the Microsoft Solution Providers. Solution Providers offer a wide range of fee-based services, including creating custom macros. For more information about Microsoft Solution Providers, call Microsoft Customer Information Service at (800) 426-9400. In Microsoft Excel 7.0 and Microsoft Excel 97, you can use the OnSave property to specify a macro that runs after you initiate saving a workbook, and before Microsoft Excel saves the workbook.
Example of the ProblemThe following example demonstrates the use of the OnSave property:
Sub SetOnSaveTrigger() ActiveWorkbook.OnSave = "WorkbookSaving" End Sub Sub WorkbookSaving(Arg As Boolean) Application.ScreenUpdating = False MsgBox "Now saving file!" End SubAfter you run the first macro, Microsoft Excel automatically runs the second macro each time you save the active workbook.
Turning off Screen UpdatingYou can turn off screen updating while a macro runs by including the following line of code in the macro:
Application.ScreenUpdating = FalseYou can enable screen updating by setting the ScreenUpdating property to True. Usually, this step is not necessary: Microsoft Excel automatically enables screen updating when the macro stops running. However, there is one exception to this rule. If a macro that is run by the OnSave property contains a command to turn off screen updating, Microsoft Excel does not enable screen updating automatically when the macro is finished. When this behavior occurs, Microsoft Excel appears to stop responding (hang). However, the program is not "frozen." The program is not redrawn on the screen correctly, which prevents you from using any part of the program.
Example of the ResolutionTo prevent the problem, enable screen updating by resetting the ScreenUpdating property to True before the end of the macro. For example, change the example in the "Example of the Problem" section to the following:
Sub WorkbookSaving(Arg As Boolean) Application.ScreenUpdating = False MsgBox "Now saving file!" Application.ScreenUpdating = True End Sub |
Additional query words: XL97 hung freeze frozen locked stopped
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |