search

microsoft / advanced-formula-environment

Create, edit, and reuse formulas in Excel
https://aka.ms/get-afe
MIT License
113 stars 11 forks source link

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

Open santiago-afonso opened 4 months ago

santiago-afonso commented 4 months ago

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!!