CAUTION the Appleworks MACRO() function has nothing in common with Excel macros.
It's just a function calling an ApppleScript and passing some parameters.
=MACRO(":ƒµƒ:µ bessel.app",2,"lecalcul",A1,B1)
=MACRO(":ƒµƒ:µ neg_en_rouge.app",2,"boulot",row(),column(),formula)
=MACRO(":ƒµƒ:µ lettre_en_rouge.app",2,"boulot",row(),column(),formula,letter)
=MACRO(":ƒµƒ:µ colorise.app",2,"boulot",row(),column(),formula,mode,"lim1;lim2;lim3")
The parameter ":ƒµƒ:µ colorise.app" is used to tell to AppleWorks:
call the script which is stored in your SCRIPTS folder in the subfolder "ƒµƒ" and is named "µ colorise.app"
I used these rules so that
(1) I was able to easily recognize scripts written to be triggered by MACRO()
(2) These scripts when't directly reachable by the user in the AppleWorks 's SCRIPT menu.
The function's name may be confusing.
It was defined whan AppleWorks was also able to use macros.
The MACRO() function was able to call macros as well as scripts.
If, as I wish, the Numbers team introduce such a feature, it would be better to use an other name like CALLSCRIPT
Yvan KOENIG (VALLAURIS, France) jeudi 1 octobre 2009 10:25:14