It worked okay for me, but I could force it if I made the function private.

--
HTH

Bob Phillips

"OE" wrote in message
...
In previous versions of Excel, I could categorise UDFs using;

Application.MacroOptions Macro:="myUDF", Category:=2

(for Date & Time functions)

but now I get an error :
Method 'MacroOptions' of object '_Application' failed. [note the leading
underscore].

This is as used for quite sometime & appears in Help of Excel 2002 & XP.
Any
clues?