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.
This happens when Excel attempts to redraw the screen to show changes made by the running macro. If you use the macro recorder, you may have noticed that it's fond of using the Select method to explicitly reference things.
With the new encryption scheme, protecting and unprotecting a worksheet in code takes a touch longer. I don’t know what exactly to do about the protection problem.
My code opens templates, unprotects them, writes stuff, combines them into a final report, and reprotects them.
Specifically, built-in updating features and explicit references to the sheet or a range will slow down your code.
Admittedly, with today's fast systems, simple macros won't always need optimization.