JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,691
- Office Version
- 365
- Platform
- Windows
I am in the process of moving from an old XP machine and Excel 2007 to a brand new and infuriatingly frustrating Surface Book Pro running Win 10 and Office 2016.
I just copied over a macro-enabled workbook (.xlsm) that works just fine on my XP machine. It has just one little UDF in a code module. On Excel 2016, that UDF gets a #NAME ? error.
I suspect this has to do with the security settings, but I cannot figure out which one to turn on or off.
Help!!!
I just copied over a macro-enabled workbook (.xlsm) that works just fine on my XP machine. It has just one little UDF in a code module. On Excel 2016, that UDF gets a #NAME ? error.
I suspect this has to do with the security settings, but I cannot figure out which one to turn on or off.
Help!!!
