About this document
Optimize VBA Macros with ScreenUpdating by Morgen Pomantow-Tangka is a document available to read on EtoBox.
This document provides instructions for displaying a progress indicator while macros are running to avoid slowdowns from actual progress bars. It describes adding a shape named "Rectangle 1" to a sheet and writing a macro to toggle its visibility. The macro is run before and after the slow code to display the shape while ScreenUpdating is turned off to speed up the macro.
- Author
- Morgen Pomantow-Tangka
- Language
- EN