View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default How to assign a Category to a custom function?

Toby,
You are welcome.
Oregon State was the last major college football team to give up
Single Wing football. They haven't been the same since. <g
Regards,
Jim Cone

"Toby Erkson" <t o b y e a t b i d a t a d o t n e t
wrote in message
...
Thank you Jim, works perfectly!!

P.S. Go Beavers! ;-) My brother-in-law is a Duck fan...it's true you can't
pick your relatives :-D
--
Toby Erkson
http://www.bidata.net/


"Jim Cone" wrote in message
...
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