I have created an .xlam file that contains 7 UDFs. In the ThisWorkbook I have assigned 5 of the 7 functions in to a custom UDF category using code like this
There are 2 of the functions that I do not want to show up in the "Custom Functions" category, but when I removed them from the ThisWorkbook code, they move over to a different category. I think in an earlier version I must have somehow coded them into a different category, but I can't remember where else to change this. Any thoughts?
Code:
Application.MacroOptions Macro:="myfunction", Category:="Custom Functions", _
Description:="Custom Function #1"
There are 2 of the functions that I do not want to show up in the "Custom Functions" category, but when I removed them from the ThisWorkbook code, they move over to a different category. I think in an earlier version I must have somehow coded them into a different category, but I can't remember where else to change this. Any thoughts?