You must set the Screen Updating property to True when the procedure finishes or when it stops after an error. You can increase the speed of some procedures by keeping screen updating turned off. Insert Paragraph After End With If x Mod 50 = 0 Then Active Document. Function Status Bar(Optional var Query As Variant) Dim Stat As Variant If Not Is Missing(var Query) Then If var Query "" Then Stat = Sys Cmd(ac Sys Cmd Set Status, "Query Running: " & var Query) Else Stat = Sys Cmd(ac Sys Cmd Clear Status) End If Else Stat = Sys Cmd(ac Sys Cmd Clear Status) End If End Function My only idea is that I set Echo and Set Warnings to NO at beginning of macro and set them to YES at end.But I sent them to yes *after* my last status bar update, and that status bar message still displays.Many people write their own macros to manipulate the information in a workbook.
He is president of Sharon Parq Associates, a computer and publishing services company. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Tell the user what's going on and provide an indication of progress, ideally every three to ten seconds.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. This example turns off screen updating and then adds a new document. This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.You can find a version of this tip for the older menu interface of Excel here: Turning Off Screen Updating.
For example, if the user clicked a button called 'cmd Run' then you could add this line of code to the start of the VBA code: Run.