Dropdown lists stuck issue
gokork
Posted messages
5
Registration date
Status
Member
Last intervention
-
gokork -
gokork -
Hello forum,
So, I have an Excel 2007 file for wall calculations, with dropdown lists to select a type of opening that can be inserted into the wall, but when I protect my sheet, no matter how much I select the cells linked to these dropdown lists, they remain inaccessible.
Can you help me with this issue?
Thanks in advance for your upcoming responses.
Sorry for the Excel file; I can't seem to insert it :/
Configuration: Windows 7 / Chrome 23.0.1271.97
So, I have an Excel 2007 file for wall calculations, with dropdown lists to select a type of opening that can be inserted into the wall, but when I protect my sheet, no matter how much I select the cells linked to these dropdown lists, they remain inaccessible.
Can you help me with this issue?
Thanks in advance for your upcoming responses.
Sorry for the Excel file; I can't seem to insert it :/
Configuration: Windows 7 / Chrome 23.0.1271.97
6 answers
Hello,
Before protecting your sheet, you need to select the cells for the validation lists, format cells, protection, uncheck locked. Then protect the sheet, uncheck select locked cells.
Best regards
Before protecting your sheet, you need to select the cells for the validation lists, format cells, protection, uncheck locked. Then protect the sheet, uncheck select locked cells.
Best regards
Hello,
I have unlocked all my drop-down lists, I have removed the selection of locked cells, but I do not see what the validation list cells are. Can you enlighten me?
I have unlocked all my drop-down lists, I have removed the selection of locked cells, but I do not see what the validation list cells are. Can you enlighten me?
Well, I have them in all my sheets, there isn't a single sheet without a list
to respond to Vaucluse: I have no results, and therefore my dropdown lists are created using the developer, insert, dropdown list.
to respond to Vaucluse: I have no results, and therefore my dropdown lists are created using the developer, insert, dropdown list.
Hello,
Just a little clarification: the columns that contain your lists must be on the same sheet that you are using. For example, if you are using the Feuil1 tabs for your work, the data in the drop-down lists should also be in Feuil1. The 2010 version of Excel allows you to place the contents of drop-down lists on other sheets, for example, one called REFERENCES. So, your file on Feuil1 only contains the data from your file, sourced from your drop-down lists. Is that a bit clearer???
Looking forward to it.
RobiQuébec
Just a little clarification: the columns that contain your lists must be on the same sheet that you are using. For example, if you are using the Feuil1 tabs for your work, the data in the drop-down lists should also be in Feuil1. The 2010 version of Excel allows you to place the contents of drop-down lists on other sheets, for example, one called REFERENCES. So, your file on Feuil1 only contains the data from your file, sourced from your drop-down lists. Is that a bit clearer???
Looking forward to it.
RobiQuébec
Hello everyone
small remark RobiQuebec, (unless I'm mistaken, which does happen quite often)
your precision is only valid for dropdown lists when going through Data / Validation.
In this case, Excel signals the impossibility of processing the request with a message, and the problem can be circumvented by giving a name to the list and using that name instead of the field address for validation. And this is true regardless of the version of Excel (at least from 2003 onwards)
However, when going through the developer and inserting a dropdown list as gokork specifies, the affected field can very well be on another sheet. Of course, the receiving cell must not be locked, but the menu still displays the list.
Thus, unless his explanation is incorrect, this is not the source of the problem because the principle he uses, tested on two different protected sheets, does not yield the results he reports
But what is curious in his messages is that he states once using the cells to display the dropdown menu, thus through Data / Validation, and another time having used the developer which, in turn, displays a dropdown list button, but does not require the selection of the receiving cell.?
.
We can only ask him to clarify this or to submit an example of his model at:
https://www.cjoint.com/
coming back here to post the link provided by the site
If not, and while waiting, we can advise him, to have the list directly in the cell.:
_ to create his lists on a possibly hidden sheet
_ to name them (formula / Define a name)
_ to unlock the cells to be equipped
_ to go through Data / Validation / list and
=name of the list
best regards
small remark RobiQuebec, (unless I'm mistaken, which does happen quite often)
your precision is only valid for dropdown lists when going through Data / Validation.
In this case, Excel signals the impossibility of processing the request with a message, and the problem can be circumvented by giving a name to the list and using that name instead of the field address for validation. And this is true regardless of the version of Excel (at least from 2003 onwards)
However, when going through the developer and inserting a dropdown list as gokork specifies, the affected field can very well be on another sheet. Of course, the receiving cell must not be locked, but the menu still displays the list.
Thus, unless his explanation is incorrect, this is not the source of the problem because the principle he uses, tested on two different protected sheets, does not yield the results he reports
But what is curious in his messages is that he states once using the cells to display the dropdown menu, thus through Data / Validation, and another time having used the developer which, in turn, displays a dropdown list button, but does not require the selection of the receiving cell.?
.
We can only ask him to clarify this or to submit an example of his model at:
https://www.cjoint.com/
coming back here to post the link provided by the site
If not, and while waiting, we can advise him, to have the list directly in the cell.:
_ to create his lists on a possibly hidden sheet
_ to name them (formula / Define a name)
_ to unlock the cells to be equipped
_ to go through Data / Validation / list and
=name of the list
best regards
Hello,
Sorry for the delay in my response. Here is my Excel file containing the different sheets and dropdown lists in question: http://cjoint.com/?CAjuEvt05jk.
For your information, I haven't tried the Vaucluse technique stating:
_ to create lists on a possibly hidden sheet
_ to name them (formula / Define a name)
_ to unlock the cells to be equipped
_ to go through Data / Validation / list and
= name of the list
I'm going to try that right away :) Can you give me your thoughts on my spreadsheet regarding the dropdown lists? And try to find out why the sheet protection also protects my dropdown lists.
Thank you for your responses and your future responses :)
Sorry for the delay in my response. Here is my Excel file containing the different sheets and dropdown lists in question: http://cjoint.com/?CAjuEvt05jk.
For your information, I haven't tried the Vaucluse technique stating:
_ to create lists on a possibly hidden sheet
_ to name them (formula / Define a name)
_ to unlock the cells to be equipped
_ to go through Data / Validation / list and
= name of the list
I'm going to try that right away :) Can you give me your thoughts on my spreadsheet regarding the dropdown lists? And try to find out why the sheet protection also protects my dropdown lists.
Thank you for your responses and your future responses :)