1. It has to be in a regular module, not a sheet module
2. You may have to use

application.volatile

as the first line


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Paul Schrum" wrote in message
...
Howdy folks,

Sorry about the Newbie question here, but I could not find anything
about this in my web and groups searches.

I am using Excel 2003. I am familiar with VBA programming, but I am
new to VBA programming in Excel.

A few days ago I developed a non-trivial custom function in VBA. I
got it to work and everything was fine. I closed the file, went home,
and slept pretty okay.

The next day I wanted to work in the spreadsheet more. But when I
opened it, all the cells which call my custom function display #NAME.
These same cells worked fine on the same session in which I developed
the function. Can someone tell me what I must do to get the custom
function to work seamlessly -- as if it were just another function
available to all cells in that work book?

TIA

- Paul