User-Defined-Functions in Office 365

[Bernie Deitrick]

Hello everybody -

In a nutshell, just opening a workbook with UDFs defined within the workbook's project just returns #NAME? to all the cells with UDF calls. That makes it look like UDFs don't work in Excel 365 - is there a good resource to explain how /what I need to do?

Thanks all,

Bernie

[Bernie Deitrick]

Well, it is not well-publicized, but macros are for desktop, and the new "scripts" are for 365, and never the twain shall meet. So any solution using VBA needs to be run in Excel desktop.