Hi all
I have created a spreadsheet (xl97) using formulas, userforms and some
buttons spanning approx 7 worksheets. While new to
vb, it's size seemed a
little large (740kb) and so I have done some investigating.
I first deleted the contents of module1 which decreased the file size to
624kb. I then progressively deleted all the worksheet contents (saving as I
went) until I got down to one worksheet and one with a number of charts on.
The filesize had progressively decreased to 382KB.
I then deleted my (empty) module1 and the filesize reduced to 93KB when
saved. Thats nearly 300KB stored in an empty module1. Can anyone shed some
light on the space waster for me.
Thanks
Tony.