I keep an XLStart file "wjm.Library.XLS" that opens automatically and
which I use to store macros I use in various programs. Simple Excel
extensions I've created and use.

Today I had a problem I wasn't clever enough to fix with a macro so I
created a simple function with VBA in my library file. It works and
tests ok from the library worksheet so now I'm ready to use it.

For some reason, my real worksheet cannot find the function I created.
Both worksheets are open, my library and my real work. It can find the
macros I use, but not the new function. When I use it from my work
file, I get the error #NAME? back.

Is there something I need to do to tell the worksheet to look in the
default library file to find this?

Thanks...

Bill