Macros certainly do increase the file size; anything you put in a
workbook increases its size. The question is really whether that
increased size is significant. And the answer to that depends on how
much code you actually have. My overall experience is that VBA code
doesn't increase the file size of a workbook significantly. One
embedded JPG can add as much, if not more, to the file size than would
a few thousand lines of VBA.

VBA is already stored in a somewhat compressed manner and there isn't
really a way to further compress it.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)


On Thu, 9 Oct 2008 13:43:01 -0700, lenoxjoe
wrote:

I have an Excel file with multiple (220+)macros in it. Does this greatly
increase the overall size of the file?

If so, is there a way to reduce the file size (by manipulating the macros -
similar to compressing images)?