Help removing defined names

ASCTQSM · Feb 21st 2019

Hi,

When using the 'Move or Copy' function to replicate a workbook sheet, I get the warning attached.
Can anyone tell me where I find the name '__123Graph_A', so I can remove it? (It does not show up in the Name Manager).

[ATTACH=JSON]{"data-align":"none","data-size":"custom","height":"108","width":"697","data-attachmentid":1215154}[/ATTACH]

**AliGW** · Feb 21st 2019

Attach the workbook.

ASCTQSM · Feb 21st 2019

example attached.
copying one of the 'PSD' tabs will generate the issue I'm having.

ASCTQSM · Feb 21st 2019

example attached.
copying one of the 'PSD' tabs will generate the issue I'm having.

**Luke M** · Feb 22nd 2019

Wow, that one was buried deep. Turns out the names were hidden from the file manager. Not sure how, but they're there. If you run this short script, you'll then be able to see the names and delete them.

Code

Sub RevealSecrets()
    Dim nm As Name


    For Each nm In ActiveWorkbook.Names
        nm.Visible = True
    Next nm
    
End Sub

ASCTQSM · Feb 24th 2019

Thank you Luke M.
Excel has many dark places...

Help removing defined names

Participate now!

Share