Clean Up Macros to save file size

[Danielle123]

I Have a file that is big and most of it is in Excel. If I save in 2007 macro enabled it is only 7 meg, about 21 meg in 2003.

Ay tricks that I can do to make the file size smaller in the macros???

Most of the people still have the 2003 excel version so I am looking for ways to cleanup or shrink the macros.

[JP Romano]

I always go through each sheet, find the last used row and DELETE all the rows beneath, then do the same with the columns. Amazing how much space that saves.