Excel vba status bar screenupdating

Echo True*** WARNING ***If you use this, MAKE SURE you include error checking, and if you recieve ANY error,turn your screen updating back on.Access97 (and probably 2000, don't know yet)will NOT turn your screen updating back on, until you explicitly tell it to. You'll get a frozen application, and have to kill it useing the task manager.Its done with application.screenupdating = false and depending on the number of text files for processing it could take up to an hour (huge text files) to complete.

excel vba status bar screenupdating-77

C) How do you manually break code running with Do Events in it?I can provide the current macro I'm working on if it will help, but since I'm more interested in the general concepts I didn't want to provide specifics for any readers to get bogged down in. Do Events can cause errors in loops, especially in recursion.Does the status bar disappear from Microsoft Excel's window by accident?Do you want to hide the status bar in Microsoft Excel?Can anyone tell me the VB to stop my Excel Macro from updating the screen while it runs.

In other words - when I click run - I just want a message saying "Macro Running" or something - then the code will run and finish and the finished position will be displayed with a message like "Macro Finished".The status bar portion of the Excel screen gives you a simple and convenient method do display message to the user.You can use it to display the progress of a VBA procedure, or indicate that the procedure is complete.The View Options of Kutools for Excel makes it possible to show or hide most of Microsoft Excel settings quickly, such as Inner Tabs, Formula Bar, Status Bar, Windows in Taskbar, Gridlines, Page Breaks, Display Zeros, Vertical Scrollbar, Horizontal Scrollbar, Sheet Tab, … It will save your time in looking for these setting when you need to show or hide them. This is extremely helpful as my status bar had disappeared for a reason I cannot identify.I haven't realized it before that this function is so essential for many tasks I have been performing everyday.How do I let the user know the number of text files processed for example when screenupdating = False???