How can I use drop down list when it is protected?

  • Thread starter Thread starter Bradley Tom
  • Start date Start date
B

Bradley Tom

Hi there,
I can not use drop down list using combo box under form
tool when the sheet is protected. But the cell ( Allow
users to edit ranges..) can be typed or modified when the
sheet is still protected.
Can you please advise me how to solve the problem?

Thnks
Bradley Tom
 
I think you've encountered a "limitation". The only workaround I can think
of is to assign a macro to the dropdown that will actually place the drop
down's value in the cell, and remove the "linked cell" from the dropdown's
properties. The macro might be like this:

Sub DropDown1_Change()
On Error GoTo SupplyPassword
Range("B1").Value = Sheet1.DropDowns("Drop down 1").Value
Exit Sub
SupplyPassword:
MsgBox "Please unlock the input range before using this dropdown"
Sheet1.DropDowns("Drop down 1").Value = Range("B1").Value
End Sub
 
Another option. Maybe just hide that unlocked linked cell in a hidden column or
row. (most people won't even notice).

If you think that's too dangerous, maybe put it on another worksheet and hide
that worksheet.
 
Back
Top