Sorry Fred, I just realized your first post mentioned Excel 5, where
the method for creating UDFs might have been radically different. Yes
you put the code in a standard module by pressing Alt-F11 to access
the VBIDE, then going to Insert Module in the workbook in which you
want to use the function.


On Sep 20, 8:40*pm, "Fred Allen" wrote:
Okay, the UDF has to be in a Module, it can't be in the code for a worksheet
or even ThisWorkbook.

"Fred Allen" wrote in message

...



I did just that, and that is what the MS article says. So at least I know I
am on the right track (with VBA UDF, which operate differently than the old
XLM UDF). I guess it is some trick in Excel 2007 (or Vista).

Thank you for confirming how I thought it was supposed to work. That does
help!