On Fri, 2007-07-27 at 23:47 -0400, Andrew Douglas Pitonyak wrote:
Thank you so much for your kind and fast answer, I tried everything in the documentation to no avail. can you please give me, at your earliest convenience, all details on how to : "explicitly load the library containing the worker macro" Best regards D.Gaudry > 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. > -- Daniel Gaudry Ph. D. 9 Avenue calmels 92270 Bois Colombes FRANCE +336 64 19 50 09 [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
