There should be an inbuilt limit on the numbers of named ranges a user can create of 3. If he can fax Microsoft with incontrevertible proof that he's a seasoned and capable spreadsheet developer then he gets given one of those very long keys which he can use to unlock the number of names he can define.