{"id":3352,"date":"2021-11-03T13:00:21","date_gmt":"2021-11-03T13:00:21","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=3352"},"modified":"2021-11-03T13:02:07","modified_gmt":"2021-11-03T13:02:07","slug":"solved-in-cell-drop-down-not-working-if-sheet-protected","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/in-cell-drop-down-not-working-if-sheet-protected\/18736.html","title":{"rendered":"Solved In Cell Drop Down Not Working If Sheet Protected"},"content":{"rendered":"<p>I would like to be able to use the in cell data validation functionality in a cell when the sheet that cell is on is protected. The cell with data validation is unlocked and the sheet it is on is protected abd attempting to click on the cell gives me the usual &#8216;cant do this when the sheet is protected error).<\/p>\n<p>Simply unprotecting the sheet means is works but I would like to be able to protect the sheet and only have this cell locked.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":4},"question-category":[53],"question_tags":[],"class_list":["post-3352","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/3352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=3352"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=3352"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=3352"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=3352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}