Layout recreation/reset utility
Sub Project #6
Layout recreation/reset utility
Had to learn:
Optimization of VBA scripts with heavy cell manipulation.
The project itself:
The layout would often break since they needed access to every cell in the file, we couldn't easily protect them, so the choice was made to create a layout recreation tool. The tool recreates the entire layout of every sheet in less than a second, making it very convenient to use. It uses a variety of rules created using VBA that can, theoretically, be activated individually.
More about this project
Parent project: Setting instruction sheet