Screenupdating false


Action ............................................... Arg uments Set Warnings ................................... On = No Open Query................................... View = Datasheet; Data Mode = Edit Set Warnings .....................................

Certain vba macros / codes take a long time to run or execute the actions required. Sometimes, there could be one or more macros which cover multiple processes and this status bar will be useful to know at which process, the macro has reached.

screenupdating false-52

I would like the queries to be invisible while they are running, but currently the user sees 50 query windows open/close which is ugly.

Is there a way to automatically minimize/hide query windows or disable screen update?

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.

Don't forget error handling & turn the screen on before you try to msgbox an error or exit the sub.