Another thing to try, which I don't think Rob's utility does, is to
re-create the project, by exporting the modules, and then importing then
into a new workbook. This often reduces the size (but it starts to grow
again as you further develop <g).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joe HM" wrote in message
oups.com...
Hello -

I was wondering if there is a way to somehow reduce the size of the VB
code so that the Excel file gets smaller. I have developed some code
in a template that will be used many times and I would like to reduce
the file size. Is there some way of compressing it? I was thinking
about stripping out all leading tabs/spaces and comments? Is there
anything else I could do?

Thanks!
Joe