MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


Posted by Dave Hawley on March 22, 2001 10:53 PM

Hi Veronica

I don't think so!

But if you push Shift+F3 the function wizard will appear. Or maybe make use of "Auto Correct" or copy another cell with the UDF and edit it.

Dave

OzGrid Business Applications

Posted by mseyf on March 23, 2001 6:09 AM

you could create an add-in with the functions you want to be accessable to any workbook.

Mark