$$Excel-Macros$$ Re: User Defined Function Question

2009-04-27 Thread Ashish Jain
Hi Jake, He is right and I won't say that it's absolutely impossible. Using VBA only it's pretty not possible. By Overriding the the function's class in a specific dll, you can do so. But for that you should be aware of the dll name, class name and the knowledge of API Prog. and building+deployin

$$Excel-Macros$$ Re: User Defined Function Question

2009-04-24 Thread Jake
Thanks Ashish. I thought it might be something like that but I had actually pinged John Walkenbach about it and he said he's able to see his functions in that pop-up box. In retrospect, I may not have been clear about what I was asking and he was talking about something else. Again, thanks for

$$Excel-Macros$$ Re: User Defined Function Question

2009-04-19 Thread Ashish Jain
Hi Jake, No, there is no way to get your function listed in that box and the reason is that you're using code behind(VBA). This restricts your function to be used from a workbook only where your function code is placed. Maximumly you can add it to a personal workbook or in an add- in but still th