If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using dropdown in protected sheet
I am having trouble choosing items from a drop down list when my sheet is
protected. In the same file I have certain areas where this is not a problem at all, but everytime I try to change the cell value via dorp down, or empty the cell, I get a "shete is protetced" type error. I thought maybe it had to do with the fact that my drop downs are in merged cells, but I unmerged them and had the same issue. Any thoughts? |
#2
|
|||
|
|||
Using dropdown in protected sheet
Hi,
It looks like that particular cell or a range comprising that cell has been protected, Unprotect that cell to use the drop down -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "veggies27" wrote in message ... I am having trouble choosing items from a drop down list when my sheet is protected. In the same file I have certain areas where this is not a problem at all, but everytime I try to change the cell value via dorp down, or empty the cell, I get a "shete is protetced" type error. I thought maybe it had to do with the fact that my drop downs are in merged cells, but I unmerged them and had the same issue. Any thoughts? |
#3
|
|||
|
|||
Using dropdown in protected sheet
Is this a Data|validation cell?
If yes, then unlock that cell. And yes, this behavior changed. (I think xl2k the cell could be locked. In xl2002, the cell has to be unlocked. I may be wrong with the versions, but there is a difference somewhere!) veggies27 wrote: I am having trouble choosing items from a drop down list when my sheet is protected. In the same file I have certain areas where this is not a problem at all, but everytime I try to change the cell value via dorp down, or empty the cell, I get a "shete is protetced" type error. I thought maybe it had to do with the fact that my drop downs are in merged cells, but I unmerged them and had the same issue. Any thoughts? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|