Each time the Workbook module is saved, the Name's Visible property is reset to TRUE

[santiago-afonso]

Hello again! I'm here to report a new issue. Say that I use the AFE to create a named lambda in the Modules / Workbook tab (MyUdf = lambda()), then I set it to hidden running ActiveWorkbook.Names("MyUDF").Visible = False in the VBA editor immediate window. The UDF correctly does not show in the Named Ranges dialog.

Now I use the AFE to make a change, it could be as trivial as adding a comment to the top of the Workbook module, and press save on the AFE editor. Then MyUDF is back to Visible = True without notice.

The AFE should preserve the Visible property of any existing name.

Thanks!!