Names can be hidden, so Insert=Name=Define may not show them. In the
troublesome workbook make a blank sheet active, then go to the VBE
(Alt+F11), do insert=Module and paste in the below code. Then do Alt+F11
to return to the worksheet and then do Tools=Macro=Macros, select
ShowNames and click run.

Sub ShowNames()
i = 1
for each nm in activeWorkbook.Names
cells(i,1).Value = nm.name
cells(i,2).Value = nm.RefersTo
cells(i,3).Value = nm.Visible
i = i + 1
Next
End Sub

--
Regards,
Tom Ogilvy

"Michael31" wrote in message
...
When I copy a worksheet I get the repeated message box that the
destination
workbook already contains the name "a", "aa", "prntoutline", "ssd", "q"
and
"zz".

I have to select yes to each message box to allow the worksheet copy to
complete itself.

I do not have these names within the worksheet (chekced by
InsertNameDefine).

How can I delete these nsmaes that do not seem to exist?

Thanks.