Protecting Range Names

F

Frederick Chow

Hi all,

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

Frederick Chow
 
D

Dave Peterson

You can hide names in code.

I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

His utility can do this pretty quickly.
 
B

Brett

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?
 
D

Dave Peterson

I've never had trouble with names disappearing.

You may want to share the names that are going away--maybe there's something
special with them.
 
Top