40 Modules Version

Sub Project #8

40 Modules Version

The project itself:

I just copied the first project, adapted it to have 40 pages, changed a few tiny parts of the code because the layout was different, then ran "Reset Layout" (with the Layout recreation/reset utility, see other sub-project), and everything was basically done... until I realised it was way too slow.

It took a lot of tiny changes to optimize it enough to work in under a second in most cases. As most cases only use less than 20 pages, they're only slightly slower than the 14 units version, but there are cases using over 30 pages, those can take 1-3 seconds, depends on how quick Excel works that day (yes, that's still an issue in 2024). This is mostly due to the entire recreation of the layout for every pages every time the script is used, which is technically optional, but to prevent printing issues, it's better to run it each time.

More about this project

Parent project: Setting instruction sheet