Optimize calculation time by shutting of display during calculations
To optimize the calculation speed for complex or many calculations you can stop refreshing the display until all calculations are done.
Synchronize displayrange and activecell when changing worksheets
This code allows one to navigate between worksheets, where the visible range as well as the activecell are kept the same. For example: if one scrolls down and right and selects cell X55 (Activecell) and sets the zoom percentage to 75%, then moves to sheet2, then in this sheet the same screen will be shown including cell X55 selected.
Suppress display alerts
This VBA command suppresses display alerts