I've inherited a workbook that has some corrupt names in it (they begin with
non-printing characters) that link to non-existant workbooks. I'd like to
delete the names, but it seems that the menu commands won't let you do that
unless the first printable character is a zero. Is there any VBA method to
delete such names or at least edit them to a deletable form?
--
Al C

Have you tried NameManager
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

--
__________________________________
HTH

Bob

"Al" wrote in message
...
I've inherited a workbook that has some corrupt names in it (they begin
with
non-printing characters) that link to non-existant workbooks. I'd like to
delete the names, but it seems that the menu commands won't let you do
that
unless the first printable character is a zero. Is there any VBA method
to
delete such names or at least edit them to a deletable form?
--
Al C

Thanks for the reminder. That's one of my add-ins, but I need it so
infrequently that I forgot about it.
--
Al C

Really, it is the one of only three 3rd party addins I have installed, and I
use it all the time.

--
__________________________________
HTH

Bob

"Al" wrote in message
...
Thanks for the reminder. That's one of my add-ins, but I need it so
infrequently that I forgot about it.
--
Al C