Calc Guide

Figure 300: Warning if macros are disabled
If you choose to disable macros, then when the document loads, Calc
can no longer find the function.
Figure 301: The function is gone
When a document is created and saved, it automatically contains a
library named Standard. The Standard library is automatically loaded
when the document is opened. No other library is automatically loaded.
Calc does not contain a function named NumberFive(), so it checks all
opened and visible macro libraries for the function. Libraries in
OpenOffice.org Macros, My Macros, and the Calc document are
checked for an appropriately named function (see Figure 291). The
NumberFive() function is stored in the AuthorsCalcMacros library,
which is not automatically loaded when the document is opened.
Use Tools > Macros > Organize Macros > OpenOffice.org Basic
to open the OpenOffice.org Basic Macros dialog (see Figure 302).
Expand CalcTestMacros and find AuthorsCalcMacros. The icon for a
loaded library is a different color from the icon for a library that is not
loaded.
Click the expansion symbol (usually a plus or a triangle) next to
AuthorsCalcMacros to load the library. The icon changes color to
indicate that the library is now loaded. Click Close to close the dialog.
Unfortunately, the cells containing =NumberFive() are in error. Calc
does not recalculate cells in error unless you edit them or somehow
change them. The usual solution is to store macros used as functions in
the Standard library. If the macro is large or if there are many macros,
Chapter 12 Calc Macros 349