I am working on a template that, granted, is fairly complicated - about 32 pages of code when printed and 6 userforms - and have been doing so on an almost continuous basis for more than two months.
I noticed recently that the size of the template has been growing every time it is saved (even if the work done was to remove some code!) and within the next save or two it is going to go over the 1Mb mark.
A template this size is going to have operational complications (especially if it and its two almost identical sister templates keep growing every time they are edited!), so does anyone know of a way to get it to let go of all the junk it is carrying and return to a more sensible size?