Changing Properties of AdxExcelFunctionDescriptor

Add-in Express™ Support Service
That's what is more important than anything else

Changing Properties of AdxExcelFunctionDescriptor
Changing Properties of AdxExcelFunctionDescriptor 
mwynn




Posts: 28
Joined: 2015-05-12
I have an XLLModule embedded in my Add-in project. I would like to modify the properties of an Excel function description (AdxExcelFunctionDescriptor) via code during run-time. For example, I want to change the visibility and description of a function.

I've tried changing properties as follows:
XLLModule1.CurrentInstance.AdxExcelFunctionDescriptor1.Description = "Test Description"
XLLModule1.CurrentInstance.AdxExcelFunctionDescriptor1.FunctionName = "Test Name"
XLLModule1.CurrentInstance.AdxExcelFunctionDescriptor1.IsHidden = False

But the changes don't seem to take effect during run-time.
Is this possible to do?

Thanks,
Matt
Posted 02 Dec, 2019 18:58:21 Top
Andrei Smolin


Add-in Express team


Posts: 16814
Joined: 2006-05-11
Hello Matt,

This isn't possible. The underlying Excel C API doesn't provide a means for this.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 03 Dec, 2019 04:58:19 Top