UDF works but not visible

    Hi,

    I have defined a UDF and saved it as .xlam file and then installed the plugin. Now I can access UDF in any workbook I open but I am unable to see the UDF in drop-down suggestion list which appears for excel built in function.
    For example: my function name is getPDE. So when I type =get in any cell, I did not get getPDE as one of the options.
    Can someone please suggest how to do so.

    Many Thanks,
    Rahul

    Re: UDF works but not visible


    You need to register it for it to appear in the dropdown - see this article.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login