While there are users who are happy with just a If you are thinking, “Hey I can see exactly what is going on, why would I need to display messages?

”, you may have to consider digging into optimizing your code a little.

excel application screenupdating false not working-29

The easy way is to block almost everything from view, in order to give the user the feeling that he is not in the standard Excel. Pretty much with two subs – one to deactivate all of the aforementioned at the start of the program and one to activate it back.

Something like this: Users are happy, that they do not see the status bar, grid lines, toolbar, scroll bars and the rest of the beauties from Excel. As simple as this Here comes the code: Option Explicit Sub Outstanding() Application.

Users can display custom messages on Excel’s status bar when needed, and allow excel to take over after their macro finishes executing.

Here is a short example: '======================================================================== 'A Macro to Illustrate the use of Application.

Feel free to study this step-by-step guide to be able to use the code you found: These lines, as their names suggest, turn off screen refresh and recalculating the workbook's formulas before running the macro.

After the code is executed, everything is turned back on.I intend to write about the best practices in the coming weeks, but let us get back to the issue at hand.The quickest way to display messages while the code is running is to use the Statusbar property of the Application object.We use Excel as a tool for processing our applied data. You googled a lot and found a VBA macro that solves your task.However, your knowledge of VBA leaves much to be desired.Press , then click the "No" button in the "The following features cannot be saved in macro-free workbook" warning dialog. Choose "Excel macro-enabled workbook" from the "Save as type" drop-down list and click the Save button.