Thread: Excel function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Excel function

Once you have setup the category, and added a real UDF to it, you don't need
the Excel4 macro sheet anymore, and you don't need the defined name. You can
just simply add to the category.

--

HTH

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


"Darren Hill" wrote in message
news:op.sttcqvq7ed89cl@omega...
On Tue, 12 Jul 2005 16:56:40 +0100, Bob Phillips
wrote:

http://support.microsoft.com/default.aspx?kbid=137526
How to Add a New Category to Function Category List



Neat.
If you create the excel4.0 macro sheet in the personal.xls workbook, can
you use add UDF's contained in other workbooks to that category?
------------------
Darren