hi,

MacroOptions, méthode
but this functionality appears to be not operational in excel2007.



Sub Test()
Application.MacroOptions Macro:="MyFunction", Category:=7, _
Description:="short description", _
HelpFile:="C:\MyHelpFunction.CHM", _
HelpContextID:=4050
End Sub


0 No category appears only in All
1 Financial
2 Date & Time
3 Math & Trig
4 Statistical
5 Lookup & Reference
6 Database
7 Text
8 Logical
9 Information
10 Commands normally hidden
11 Customizing normally hidden
12 Macro Control normally hidden
13 DDE/External normally hidden
14 User Defined default
15 Engineering

--
isabelle