multiple selection dropdown list not working on protected sheet

Anonymous

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.....

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.

0 comments

Answer accepted by question author

Anonymous

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

0 comments

15 additional answers

Deleted

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
Anonymous

2017-03-15T14:52:29+00:00

Never mind. I made it myself!!Yeah!! Thank you anyway!!
Was this answer helpful?

0 comments No comments
Anonymous

2017-03-15T13:52:06+00:00

Hi Norman,

How can I make the check boxes remain checked when I click on the cell again, and if I uncheck any item, it removes from the cell value? Currently if I click the cell again, all items in the form are unchecked and if I check a item which was already in the cell, it will add duplicate items. How can I update the code to solve this problem?
Was this answer helpful?

0 comments No comments