Errors with 'Named Ranges'

[ilcaa]

i deleted alot of queries and tables in my workbook, removed any data model tables as well, saved my workbook several times. (see screenshot below)

if I go to Name Manager there are no names listed. all deleted. If i use the name drop-down menu. Old names appear that are NOT in my workbook. The workbook is a XLSM. if i go to VB editor, i can see the old workbook names, if i try to save as standard XLS i get error. again, this workbook has been saved multiple times already as XLSM.

here is a screenshot. is there a way to get rid of drop-down name references? how can i delete the VB workbooks listed to match Excel sheets?

thanks for any help troubleshooting this.

 

[Fluff]

Those are probably names of tables on the hidden sheets. Unhide the sheets & you can then delete the sheets.

 

[ilcaa]

Those are probably names of tables on the hidden sheets. Unhide the sheets & you can then delete the sheets.

thanks, your right, i did have hidden sheets i did not think about...

 

[Fluff]

You might have some hidden names that use the old Excel4 functions.
Try running this & then look in the name manager.

Sub CleanNames()
   Dim Nm As Name
   For Each Nm In ActiveWorkbook.Names
      Nm.Visible = True
   Next Nm
End Sub