dg wrote:
Daniel Gaudry Ph. D.
9 Avenue calmels
92270 Bois Colombes
FRANCE
[EMAIL PROTECTED]
HI
I wrote a small macro but it is not available in my spreadsheet with the
message #NAME?. How can I load it?
Many thanks
Regards
D.Gaudry
First, let me mention that this is discussed in the Macro chapter of the
Calc documentation
http://documentation.openoffice.org/manuals/oooauthors2/
Hmm, but I see that it is not yet available. Strange. if you send me an
email, I will send it to you.
It is also mentioned in AndrewMacro.odt.
That said, the bottom line is that the library containing the macro must
be loaded and visible.
First, about "visible". A macro is visible to a document if the macro is
contained in that document, or if the macro is contained in one of the
global macro libraries ("My Macros" or OpenOffice.org).
As for loaded, if you load the macro browser and click on a library,
that loads the library. I usually place the macros that I want to call
as a Calc function in Standard (because the library named Standard is
always loaded automatically), or I at least place the called macro in
Standard and then I explicitly load the library containing the worker
macro before I call it.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
