Rick,

Thanks again for the information. I don't usually do the cross-post, unless
I feel it would relevent to other groups.

Thanks again.

"Rick Rothstein (MVP - VB)" wrote:

It looks like Dave is on to something in his post to this thread, so you
should follow up on your main question there.

As for cross-posting, the process is simple... just list each newsgroup,
separated by commas, in the Newsgroup field (this is similar to how you
would send the same email message to multiple people). When you cross-post
this way, any answers you receive any of the newsgroups will be seen in all
of the newsgroups. This is good in that you don't waste volunteers time
providing you with the same answer in one group that you already got in
another group plus you get better follow-ups from volunteers who may not
visit or see your response elsewhere. HOWEVER, you should only cross-post to
groups that your question would be appropriate in. The question you asked
here would seem to be more appropriate in microsoft.public.excel or
microsoft.public.excel.misc instead of here.

Rick


"AccessHelp" wrote in message
...
Thanks for your response. I have tried to remove it manually several
times
(Insert|Name|Define), and it would not remove. As long as I can remove
this
defined name from this workbook, I would be happy to try any method (code,
manually, etc.).

As far as posting in the group, I thought I cross-posted my message.

By the way, how do I cross-post a message in the groups? I thought I did
it
correctly.

Thanks.

"Rick Rothstein (MVP - VB)" wrote:

You posted your question in a "programming" newsgroup... are you wanting
to
do this in code?

You can do it directly from the spreadsheet.... click Insert/Name/Define
on
Excel's menu bar, select the defined name you want to delete from the
list
and click the Delete button.

Rick


"AccessHelp" wrote in message
...
Hello,

I have a workbook which contains a defined name "_|_ Print Area". I
have
been trying to remove it from the workbook several times, and I can not
remove it.

Does anyone know how to remove it?

Apprently, the defined name is referencing to a file that we created in
1999
and to a file that located in our network.

Thanks.