429 votesUnder review · 24 comments · Feature Requests and Feedback » Office Developer Tools · Flag idea as inappropriate… · Admin →
@Bill S - whining or otherwise, stating "learn to code" doesn't, in fact, encourage anyone to so do. I mean, apply that to being an artist. I realize a pencil isn't broken and it's dead simple to whip up a drawing, but does that really justify shunning people for insisting on raising the bar and going to a wacom since that's pretty much the norm - egads man, learn to freakin' draw and take your plebeian stench with you!
Over time, iterations of Office have brought more capability to the apps overall, so it makes absolutely no sense why there wouldn't be improvements on the IDE. It could be as simple as replacing it with VS Code or patching in to VS Code.
Too often i hear people, usually long time coders, say "there is nothing wrong with it" and while that's true - that doesn't mean it couldn't be better.
Application.ScreenUpdating = False
Application.EnableEvents = False
Those are two very common macro calls that reduce the load on the computer and speed a macro up. Other speed tips are avoiding .Select.
There's a call you can do in a macro for this already:
Application.Calculation = xlCalculationManual
You can write a function that does this in VBA already, and it's not very hard, but the issue with your idea is that on networked systems - it could be a security concern. However, you can also PowerQuery that information if there is a remote file with that information already stored.
You can already do that - View > Page Layout