How can I programmatically add a new category to the Excel Function Wizard?
H Henry Scarberry Jul 10, 2003 #1 How can I programmatically add a new category to the Excel Function Wizard?
T Tom Ogilvy Jul 10, 2003 #2 http://support.microsoft.com/default.aspx?scid=kb;en-us;213813 XL2000: How to Add a New Category to Function Category List
http://support.microsoft.com/default.aspx?scid=kb;en-us;213813 XL2000: How to Add a New Category to Function Category List
G Gord Dibben Jul 10, 2003 #3 Download Laurent Longre's FUNCUSTOMIZE.DLL and the DEMO.XLA http://longre.free.fr/english/index.html#FunCustomize Gord Dibben Excel MVP - XL97 SR2 & XL2002
Download Laurent Longre's FUNCUSTOMIZE.DLL and the DEMO.XLA http://longre.free.fr/english/index.html#FunCustomize Gord Dibben Excel MVP - XL97 SR2 & XL2002
H Henry Scarberry Jul 11, 2003 #4 Thank you for the reply but I'm looking for a way to do this from VB. Any suggestions?
T Tom Ogilvy Jul 11, 2003 #5 Laurent Longre shows some sample code and adds some cautions: http://longre.free.fr/english/func_cats.htm He has also recently built a DLL that will assist with your requirement http://longre.free.fr/english/index.html#FunCustomize Regards, Tom Ogilvy
Laurent Longre shows some sample code and adds some cautions: http://longre.free.fr/english/func_cats.htm He has also recently built a DLL that will assist with your requirement http://longre.free.fr/english/index.html#FunCustomize Regards, Tom Ogilvy