Description: I need to protect somme of the cell named ranges I create (as administrator). Even with protections on cells, even with protection on file, users can always modify the cell named ranges, doing the command "manage the names". Could it be possible to add a protection for that ? Actual Results: no protection on cell named ranges. Expected Results: being able to choose to protect (or not) cell name ranges when it's created. Reproducible: Always User Profile Reset: No Additional Info: I think excel does, already
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone else confirms it.
Please write exact steps. Do not assume it's self evident, not all use it.
Created attachment 171460 [details] example Thanks Timur, I don't really know how to technically express myself in English (I'm French) without making any mistakes in meaning, so I try: - I am creating a range named A1: A3000, for example, named "list". I wish people could enter data on this range (it remains scalable). So the cells from A1 to A3000 are not protected. I am using this named range in many formulas in my workbook (multiple sheets) My file contains a lot of sheets, a lot of named ranges, and a lot of formulas. The user must not be able to modify the formulas. I therefore protect all the cells to be protected, I also protect my entire binder. All of these protections are OK. Despite this, if a person goes to the "manage names" area, they can modify the range I created: either rename it (from "list" to "list", for example): it is not still very serious, and does not affect the results of the formulas. But they can also modify the range itself: (from A1: A3000 to A100: A300, for example). And there: the formulas will work, but all the results will be wrong, which is even worse. I've asked the community before, it doesn't appear that cell named range protection exists yet. It's easy for you to try on the example file that I upload: on this file, just go to the name box, and modify the length of the named range. despite all the protections I put on, you can do it ... and give false results. I find this to be a very serious security breach.
Thanks Timur, I don't really know how to technically express myself in English (I'm French) without making any mistakes in meaning, so I try: - I am creating a range named A1: A3000, for example, named "list". I wish people could enter data on this range (it remains scalable). So the cells from A1 to A3000 are not protected. I am using this named range in many formulas in my workbook (multiple sheets) My file contains a lot of sheets, a lot of named ranges, and a lot of formulas. The user must not be able to modify the formulas. I therefore protect all the cells to be protected, I also protect my entire binder. All of these protections are OK. Despite this, if a person goes to the "manage names" area, they can modify the range I created: either rename it (from "list" to "list", for example): it is not still very serious, and does not affect the results of the formulas. But they can also modify the range itself: (from A1: A3000 to A100: A300, for example). And there: the formulas will work, but all the results will be wrong, which is even worse. I've asked the community before, it doesn't appear that cell named range protection exists yet. It's easy for you to try on the example file that I upload: on this file, just go to the name box, and modify the length of the named range. despite all the protections I put on, you can do it ... and give false results. I find this to be a very serious security breach.
I confirm as enhancement. Guess there should be a checkbox "Protected" in Manage Names / Range Options.