What to do to make a user defined function be easy accesible?
Posted by Veronica on March 22, 2001 10:49 PM
I have more UDF in my Personal Macro Workbook. My problem is that when I need to use any of them, if I just type in a cell its name, say =Mynumber(F14), it will not work. If I chose it using the Function wizard ofcourse it works because it has the whole path ('Personal Macro Workbook'!MyNumber(F14)). To type the path is not an option because I can't memorize the damned think. There is a way to make UDF be listed just by their name without 'Personal Macro Workbook'! prefix? Thank you so much for your help.