I have written several macros and run them in various worksheets from their
home in my personal.xls file. I can not get a custom function to work from
there, though. Is this not allowed? I have several that work well in an
individual worksheet, but they die when stored in personal. When I use the
function in a formula that way I get the #NAME error for the formula result.

Any ideas will be greatly appreciated!

Alan