O'Reilly logo

Learn OpenOffice.org Spreadsheet Macro Programming by Dr. Mark Alexander Bain

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Making Macros and Dialogs Available to Everyone

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required