[libreoffice-users] Re: Macro not active when the document start

Am 11.08.2011 10:30, Johnny Rosenberg wrote:
> The macro is used as a cell function right?
> In that case, where did you put the macro? It should be placed in My
> Macros, I think, so you need to move it there if it's not there
> already.

Wrong. It has to be stored in library "Standard", either the document's 
one or the global one. "Standard" is loaded automatically and a cell 
function will be found immediately.
The functions do not contain any references to UNO objects so they 
*should* work right from the start and they *should* update 
automatically if menu:Tools>CellContents>Automatic Calculation is 
enabled and if (and only if) a referenced value has been modified.
Otherwise recalculation should be triggered on key F9.
Ctrl+shift+F9 enforces a complete recalculation of the whole workbook.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted