vijay.vizzu
Member
Dear All
Please find below code, i found this code in search engine. In this code why confirmation through msg box required to delete the hidden names & if i removed msgbox line then it gives error. Is there any to delete all hidden names without any confirmation required
[pre]
[/pre]
Regards
Vijay
Please find below code, i found this code in search engine. In this code why confirmation through msg box required to delete the hidden names & if i removed msgbox line then it gives error. Is there any to delete all hidden names without any confirmation required
[pre]
Code:
Sub Remove_Hidden_Names()
' Dimension variables.
Dim xName As Variant
' Loop once for each name in the workbook.
For Each xName In ActiveWorkbook.Names
If xName.Visible = True Then
xName.Delete
Else
MsgBox (xName)
xName.Delete
End If
Next xName
End Sub
Regards
Vijay