data validation multiple selection protected sheet

Hi Excel Guru's

I have found the following code on the forum, it allows multiple selection from a drop down list, separating the items with a comma, in a single cell

Please Login or Register  to view this content.

This code works ok

However, my sheet is protected, and once protected the above code does not work

I have seen some comments saying the function "xlCellTypeAllValidation" will not work on a protected sheet, but have not had any luck in finding a workaround

Hope you can help

Thanks in advance for any replies

Simon.xlsx

Hi Trevor, Thanks for your quick reply

That is something I had already tried, before turning to the forums for expert help

The code still does not run regardless of the cell been locked or unlocked

I also tried using the Unprotect and protect functions in my VBA Code, but no joy