VBA is stored in the workbook as byte-codes that correspond to
the text you type in. The actual text is never saved. When you
compile the code, VBA takes these generic opcodes and compiles
them in to platform-specific excodes, which are in turn read by
the run-time libraries when you run the code. VBA will also
compile code as needed at run time. As a practical matter,
clicking Compile just does a syntax check on the project.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Dave Marden" wrote in message
...
I am wondering what Compile VBA project does. I have a regular
Excel project with quite a bit of VBA being used, and I am
wondering mostly if this will compile my project into a
installable program.


Thanks,
Dave Marden