I've never thought that macro code increased the size in typical workbooks. I'd
guess that the amount of data in each worksheet has much more to do with the
size of the workbook. (Well, except for those workbooks that are mostly code
(addins and the like).)
But one thing that can increase the size of workbooks is when excel sets the
last used cell. If you hit ctrl-end, do you go to where you think the last used
cell should be? (Excel remembers what you've used and needs to be reset
explicitly).
If it goes way past where you think it should be, try some of the techniques at
Debra Dalgleish's site:
http://www.contextures.com/xlfaqApp.html#Unused
====
And if you want, you can use Rob Bovey's code cleaner. It exports your modules
(temporarily) and then reimports them. This can have some affect on workbook
size.
You can find it at:
http://www.appspro.com/
(but the next time you compile the project or run some of the macros (and then
save the workbook), the size will go up.)
