Screen Tip/Auto Completion For UDFs
Hi,
User defined function which are in the spreadsheet are included in the
AutoComplete list. So the problem lies in the fact that the functions reside
in another workbook. I tested and it makes no difference whether the
workbook containing the functions are Add-ins or Regular files.
If someone doesn't come up with a solution one approach you might consider
is having copies of the function code loaded into each workbook when they are
opened.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"FARAZ QURESHI" wrote:
Excel 2007 sure does provide a good feature of auto completion in case of
entering a built-in function so as to select one from the recommended list
instead of typing the whole. However, the UDFs I have defined in an AddIn are
not being presented so.
Any idea to overcome this and have your UDFs be listed as well?
--
Best Regards,
FARAZ A. QURESHI
|