Search code examples
c#excelexcel-dna

Toggle Hidden function with C# code Excel-Dna

I am experimenting with Excel-DNA and I am trying to find a way to toggle the IsHidden attribute of a custom function but I can't because it is a constant attribute

[ExcelFunction(name = "test", Description = "test function", IsHidden = SomeVar)]

I want to hide them when a setting is set by the user and toggle them back to visible when that setting is off.

Solution

  • The resolution of the IsHidden property is done at compilation time. If the setting you need to check needs to happen at runtime, then your best bet is register the functions yourself using the custom registration https://github.com/Excel-DNA/Registration