Hi Smitty,
You can use a macro by "Mike" kind of like you just a single
unidentifiable username in the newsgroup.
http://groups.google.com/groups?thre...0microsoft.com
the macro will go through the list of name and delete each one.
Sub DeleteallNames()
Dim nName As Name
For Each nName In Names
nName.Delete
Next nName
End Sub
Google Groups has sure gone downhill, the purpose of posting
code is so that it can be copied, Google site is taking forever
when it is functioning and the new layout for GG causes major
problems and now the messing up mouse and context menus.
I would have rather have just pointed you to the code, but I
have bookmarklets to change things (and could probably
work from original text).
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Smitty" wrote in message ...
,I was given the file. It has many names some using Asian characters. I
need none of them, but I get a long annoying sequence of queries regarding
them whenever I try to copy a sheet. (this I do often) How can I find and
eliminate these names? They do not show up when I click on the insert names
menu.