Defining Categories for Custom Functions

[Guest]

I have developed several custom functions which are loaded with an add-in.
When I use the Insert Function box my custom functions show up under the User
Defined category. I know that I can assign my functions to one of Excel's
pre-exisitng categories. Its it possbilbe to define my own categories for my
custom functions?

 

[Bob Phillips]

There is a method described by Laurent Longre in the EEE newsletter at
http://j-walk.com/ss/excel/eee­/eee009.txt

I just tested it and it still works, you just need to make sure that you
have the correct path to user32.dll.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks! This is exactly what I was looking for.

There is a method described by Laurent Longre in the EEE newsletter at
http://j-walk.com/ss/excel/eee­/eee009.txt

I just tested it and it still works, you just need to make sure that you
have the correct path to user32.dll.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

I cant seem to get this to work or to figure out how to use it. What is the
"Auto_Open" method and how is it called and by what? Is it an event? What are
the arguments to the "REGISTER" API, and what are "CharPrevA" and "CharNextA"
supposed to be? Also, what is the NbArgs argument to the Register method for?

 

[Simon Templar]

Another solution here : http://xcell05.free.fr/english/#FunCustomize

Regards.

Jason Rodman a écrit :