View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default File size grows enormously

Hi Chris,

Three suggestions:

1. See Debra Dalgleish's recommendations:

http://www.contextures.com/xlfaqApp.html#Unused

2. Download Rob Bovey's CodeCleaner AddIn:

http://www.appspro.com/Downloads/CodeCleaner.exe

3. Use both of the above.


---
Regards,
Norman




"Chris" wrote in message
...
I have an Excel sheet with lost of VBA code in. This
includes forms. The file is about 3mb big. Recently, if I
only include minimal code and save it, it will be 6mb,
next save :12 mb ect. I realised this after my computer
kept crashing, that my file is 120mb big!! please help!