multiple selection dropdown list not working on protected sheet

Anonymous
2015-04-24T15:52:27+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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
2017-03-14T19:49:50+00:00

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

Was this answer helpful?

2 people found this answer helpful.
0 comments

15 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-03-14T19:39:07+00:00

    This is brilliant!! Thank you!! it solved my problem at work!!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-04-29T22:55:23+00:00

    Hi Jalal,

        Call ProtectIt            Change to Call ProtectAll

    Indeed!

    As I have replaced the ProtectIt routine with the ProtectAll routine, the Workbook_Open  code should reflect this change. Well spotted!

    ===

    Regards,

    Norman

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-04-29T20:54:11+00:00

    Great Norman.

    Thank You.

    last thing to be modified

    In the ThisWorkbook module code:

    '=========>>

    Option Explicit

    '--------->>

    Private Sub Workbook_Open()

        Call ProtectIt            Change to Call ProtectAll

    End Sub

    '<<=========

    Was this answer helpful?

    0 comments
  4. 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