Hello again, i have a problem with ComboBox, Column B (Item Description) has data validation that when double clicked the ComboBox will activate. (The purpose of this is i want my cell to have suggestions and auto complete), The problem is i need my sheet to be protected (this is a shared workbook via network by the way), and when sheet is protected the ComboBox don't activate. I tried to unchecked the Linkedcell(Column B) and the .Locked to true but none of them works,
Hope someone help me with this.
here's my sample file.
Bookmarks