This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Have a question for Excel VBA profs.
I have an excel sheet with multiple selection dropdown list /list box . the code works brilliant.
But..
Now my problem is that it doesn't work if the worksheet is protected, even if the actual cell containing the dropdown list is unlocked. It just behaves like a normal data validation list, i.e. the code is ignored.
Is there any way to allow it to work even if the sheet is protected
Help.....
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi Carrie,
This is brilliant!! Thank you!! it solved my problem at work!!
Thank you for the kind feedback. I am pleased that the code was of assistance.
===
Regards,
Norman
Hi Jalal,
Thank you for your kind feedback.
===
Regards,
Norman
Dear Norman,
This was brilliant. You're my savior.
Great forum....Great People.
Thanks
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Dear Norman,
It's Great.
But there is an issue that sheet seems always protected. I cannot unprotect the sheet.
""in case I need to modify the protected cells""
would you help please.
file link after code modified.
Thanks