Name cannot be the same as built-in name

  • Thread starter Thread starter Luc
  • Start date Start date
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 ?
 
Back
Top