I have a VBA Excel system that is 55MB in size. There are some worksheets with a lot of data which make up most of the size.
i wrote a utility to delete each worksheet in turn, save the file then record the new file size after each worksheet delete. It runs all the way down to just a "dummy" blank worksheet.
I created a copy of my system then ran on my utility on this copy. At then end I have a file with just the dummy worksheet and all the VBA code.
The copy after all worksheet deletion is 7MB in size. Is this size therefore all attributable to the VBA code?
Thanks in advance.