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

2015-04-24T21:02:44+00:00

Appreciated.

I would like to share file link here

https://onedrive.live.com/redir?resid=ebfac460fed086a3!215&authkey=!AJbUmIuVUpgA3zs&ithint=file%2cxlsm

try to protect/unprotect the sheet. Then you can see what I explained above.

also you can view the code and help me with solution.

Thanks
Was this answer helpful?

0 comments No comments
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