View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mcpheat mcpheat is offline
external usenet poster
 
Posts: 5
Default size/space problem with module1 in VB even though it is empty

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.