Toby,
Categories...
' 0 = All 11 = Customizing
' 1 = Financial 12 = Macro Control
' 2 = Date & Time 13 = DDE/External
' 3 = Math & Trig 14 = User Defined
' 4 = Statistical 15 = Engineering
' 5 = Lookup & Reference
' 6 = Database
' 7 = Text
' 8 = Logical
' 9 = Information
' 10 = Commands
Private Sub ShouldBeFunctionCategories()
Application.MacroOptions macro:="Bootstraps", Category:=5
Application.MacroOptions macro:="Mushrooms", Category:=10
Application.MacroOptions macro:="TheRightThing", Category:=8
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Toby Erkson" <t o b y e a t b i d a t a d o t n e t>
wrote in message
When you bring up the function wizard, you can select functions by Category
(Financial, Date & Time, Database, Text, etc). How does one assign a
Category to their custom (VBA created) function so it will show up in the
appropriate Category?