I did some investigation and it is a new worksheet I added that is causing
the size increase, strangely tho the worksheets has 1 list box and 1 column
of data which is only 55 names
I Exported the offending sheet to a new workbook and deleted everything from
it, all the code everything

this one sheet is increasing the size of the workbook by over 3.6 MB

Anyone got any ideas

Thanks

"Vacation's Over" wrote:

lines of code are small

what may happen is that in developing those final lines some garbage may
collect.
try a code cleaner

http://www.appspro.com/Utilities/CodeCleaner.htm



"Nigel" wrote:

I added some code to a worksheet, a macro and a list box and it increased the
size of the worksheet quite substantially, is there anyway to prevent just a
few lines of code increasing spreadsheet size