Hello,
I have a program with named ranges. I am in the process of protecting everything. I have over 500 named ranges and want to protect them (the names). How do I do this and still allow the user to input values in the cell? In a perfect world I would like for them to be able to see the name in the name bar, but not be able to edit or delete it.
Also, is there a way to prevent the user from seeing any of the named ranges in the Name Manager?
Thanks in advance,
Dustin
Bookmarks