VBA code to delete workbook scope name

[ceytl]

My workbook and worksheet has the same scope name.

The workbook ref is broken, so I would like to delete it.

The top name is the worksheet scope, and the bottom name is the workbook scope:

I have used: ActiveWorkbook.Names("ShipMonth").Delete ...but it delete's the sheet scope name first, and I need it to delete the workbook scope.

Any ideas?

Thanks!

 

[Alex Blakenburg]

You need to make sure that the active sheet is not the sheet to which the sheet named range is scoped.
If you are on the sheet to which the named range is scoped it takes precedence over the workbook named range when you access it, whether that be to use it or delete it.

So if ShipMonth is scoped to Sheet1, you need to be on any sheet other than Sheet1 to delete the workbook version of ShipMonth.