Prevent Multiple Instances of TempCombo

I borrowed the following code from ExtendOffice. It allows me to have an autocomplete dropdown instead of validation with in cell dropdown. I noticed when I have worksheet protection turned on that when I select a cell which displays a dropdown, it causes there to appear 2 dropdowns. In order to correct this, I toggle protection on and off, but since this procedure runs with selection change, it makes things slow and clunky. Any idea how to prevent 2 dropdowns from displaying?

In order for this to run, you will need to have a combobox with a name set to TempCombo, and a few cells with validation set to in cell dropdown.

Here's the offending procedure.

Please Login or Register  to view this content.

Hi - thanks for taking a look at this for me!

Presently, I'm using several kinds of validation in the worksheet, and some cells are not validated. Those that are validated may or may not require dropdown, and I'm using the dropdown to pick from different named tables in the book. When I created the book, I only created one drop down which is set to appear if the appropriate kind of cell is selected. I did not create more than 1 dropdown, I use the same dropdown and fill its drop list from more than one location in the book. The issue is that drop down will appear anchored to more than one cell if:
A) a cell is selected that requires a dropdown

and

B) if and only if the worksheet is protected when the selection occurs.

Follow on to previous as a clarification: The combo box already supports auto complete and narrowing of the list as the user types. It also auto appears and auto hides once the user selects a different cell. The only issues are:

1) more than one instance appears when the worksheet is protected
2) the procedure I'm using requires to turn on and off the worksheet protection to prevent more than one combo appearing at a time. It's effective but a bit slow (slight lag in performance).

Any ideas? Bump?

Administrative Note:

We would love to help you with your query; however, it has been brought to our attention this same query has been posted on one or more other forums and you have not provided the required cross-post link(s).

Please read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Hi Jeff -
Sorry for the violation(s) due to cross posting. Here's the cross posted thread on Mr. Excel https://www.mrexcel.com/forum/excel-...tempcombo.html