I understand cross-posting is not appropriate.

It may cause someone to read your message many times, answers will not
appear in all groups, and it uses excess space.

Let me know if I misunderstood.


On Oct 9, 10:30 am, AccessHelp
wrote:
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.