Categorizing Custom Functions

  • Thread starter Syed Zeeshan Haider
  • Start date
S

Syed Zeeshan Haider

Hello Experts,
I have Excel 97 Pro on Win98SE.

As I have mentioned in some earlier thread that I have created some custom
function for some complex calculations. Now I am creating more and more
custom functions.
I want to put them in a separate category (categories being accessed from
Insert>Function...), say "MyPersonalFunctions", for quickly accessing them.

Can I put my custom functions in a separate custom category?
If yes then how?

Thank you,
 
G

Gord Dibben

This free add-in allows to customize VBA user-defined functions in Excel's
function wizard :

- add descriptive text to each argument
- store user-defined functions in a new category (for instance "My Functions")

http://longre.free.fr/english/index.html

Easy to use and comes with full Help/Instructions.

Gord Dibben XL2002
 
Top