HELP - Custom search text on Combo box under protected sheet.

[sasils]

Dear Excel Experts

I need urgent advise on how to do a custom search input text in combo box under protected sheet. The property of combobox is unlock as well as all the cells link to that box are unlock.

Below are vb code for this combo box.

Private Sub ComboBox1_GotFocus()
ComboBox1.ListFillRange = "BANNERALL"
Me.ComboBox1.DropDown


End Sub

The combo box LOCKED property is set to FALSE and and format control LOCKED is not tick.

Please advise thank you.