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