Home/ Questions/Q 3352
Next
Answered
computing
  • 2
Asked: 2021-11-03T13:00:21+00:00 In:

Solved In Cell Drop Down Not Working If Sheet Protected

  • 2

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 ‘cant do this when the sheet is protected error).

Simply unprotecting the sheet means is works but I would like to be able to protect the sheet and only have this cell locked.

Share

    1 Answer

    1. Best Answer
      Have you tried this in another workbook?

      I’m not seeing that behavior in a 2010 workbook. I can’t try it in 2013 until I get home tonight.

      Here’s what I did in 2010:

      1 – Sheet1!A1:A5: Entered 1 ,2 3, 4 5
      2 – Sheet2!A1: Added a Drop Down referring to Sheet1!A1:A5
      3 – Hid Sheet1
      4 – Formatted Sheet2!A1 as Unlocked
      5 – With Sheet2!A1 selected, Protected Sheet2, Allow user to Select Locked and Unlocked Cells
      6 – Accessed Drop Down and selected a value from the list
      7 – Unprotected Sheet2
      8 – With Sheet2!C1 selected, Protected Sheet2, Allow user to Select Locked and Unlocked Cells
      9 – Accessed Drop Down and selected a value from the list

      I see no difference – and wouldn’t expect to – whether the Unlocked cell is selected or not.

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      • 0