View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jason Rodman[_2_] Jason Rodman[_2_] is offline
external usenet poster
 
Posts: 1
Default Defining Categories for Custom Functions

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?

"Jim" wrote:

Thanks! This is exactly what I was looking for.

"Bob Phillips" wrote:

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)


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