VBA Code to Zoom Data Validation Drop Down Menu Won't Work in Protected Sheet

Try moving Unprotect to the FIRST line of your code
- I think the protection is preventing the macro from triggering

If that works then you will need to amend a couple of lines in your macro

Let me know and I will test a couple of things on your macro when i get home