Custom Function

Posted by Rod on November 21, 2001 7:57 PM

I know how to put macros in my personal.xls file to have them globaly available. But I cant seem to get my custom functions to work that way. I am putting my functions in a module in the personals.xls file. But I can only get the them to work if I put the function in a module of every workbook that I want to use it. Am I missing something, is there away around this.

Thank You!!
Rod

Posted by Bob Umlas on November 21, 2001 9:53 PM

If the function is not in the active workbook's vba code, then you need to refer to the function with the name of the workbook which contains the funciton. Something like
=personal.xls!xxx()

Posted by Rod on November 22, 2001 10:04 AM

Thank you Bob!!