我忘记了UDF-in-data验证限制.我认为该限制已在Excel 2010中删除.否则，AFAIK唯一的解决方法是将UDF包装在xlt中的已定义名称"中(在引用UDF的xlt中创建一个定义名称:NameValidate = MyUDF())

I had forgotten about the UDF-in-data validation restriction. I think that restriction has been removed in Excel 2010. Otherwise AFAIK the only way round it is to wrap the UDF in a Defined Name in the xlt (create a Defined Name in the xlt that references the UDF: NameValidate=MyUDF())