Can't you just right click on each module in the project explorer (VBE) and
remove the modules?

Anyway, Chip Pearson has such code at his site:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Cory Thomas " wrote in message
...
I have a project im working with right now, and the file sizes are much
too large. I have a considerable about amount of data in the
spreadsheet and a lot of VBA code.

So I was wondering if there was a way to write code to remove the code
in the spread sheet. I would much rather remove the modules and what
not than to have to copy this data to another spreadsheet.


---
Message posted from http://www.ExcelForum.com/