Name cannot be the same as built-in name

L

Luc

Opening an Excel-file using version 2007 gives below message:
NAME CONFLICT: Name cannot be the same as built-in name. Old Name:
Print_titles. New Name: (leaves area blank for you to fill in.)
In Excel 2003 the file opens without any problem.
The same error is given for the name PrintArea.

We have Office in Dutch language. Maybe the file has been saved before in
an English Office.

In Namemanager I can see double names for Afdrukbereik (English PrintArea)
and Afdruktitels (English Print_Titles).
We absolutely need to resolve this error in code.

I can delete the double names for Afdrukbereik (PrintArea) with this code:
Names("Afdrukbereik").Delete

The double Afdruktitels (English Print_Titles) are not deleted by code as:
Names("Afdruktitels").Delete or PageSetup.PrintTitleRows = ""
How can I delete these double name ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Name Conflict 1
Name Conflict 5
Name cannot be the same as built-in name 1
Name Conflict 2
NAME CONFLICT: Name cannot be the same as built-in name. 5
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
VBA group the number in the Column and Copy to the new worksheet. 0
Formula Cannot Be Converted - Function Not Available 1

Top