Excel提示这个
代码:
Sub DisplayNames() Dim Na As Name For Each Na In ThisWorkbook.Names Na.Visible = True Next End Sub
使用VBA删除名称的方法:
ActiveWorkbook.Names("Auto_Activate").Delete
2024-01-12 08:53:16
Excel提示这个
代码:
Sub DisplayNames() Dim Na As Name For Each Na In ThisWorkbook.Names Na.Visible = True Next End Sub
使用VBA删除名称的方法:
ActiveWorkbook.Names("Auto_Activate").Delete