I've recently had a serious problem with excel deleting range names in a
workbook. In the process of building the spreadsheet I have now reached over
150 named ranges. Up until recently I'd never had a problem with names being
deleted automatically, but now it happens frequently and it's always the same
2 names that get deleted.
Can anyone explain why this happens?

"Frederick Chow" wrote:

Hi all,

Are there any methods of protecting range names from being deleted? Or else
is it possible to hide names? Thanks.

Frederick Chow