If you throw your mind way back to Chapter 2, then you'll remember that we saw that libraries can be in one of three locations:
My Macros and Dialogs for personal libraries
OpenOffice.org Macros and Dialogs for global libraries
Each individual spreadsheet
Now, if you want to distribute your macros and dialogs to other people, then the most obvious solution may seem to be to include the library in the spreadsheet. And, indeed, if your potential user doesn't have access to your network, then this may be your only solution.
However, there is a major drawback in including your library in the spreadsheet. By doing this you effectively loose control of the code. In fact, all control of the code is lost ...