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

1. Please Edit your post by adding code tags around your code
- click Edit Post
- select code text
- click on # icon above

2. Your could try UnProtecting the sheet in the VBA just before zooming and Protecting it again after zooming

Me.UnProtect Password:="YourPassword"
'Zoom ....
Me.Protect Password:="YourPassword"

Or
3. Reduce the font size in your cells (by format) and then zoom the sheet to make cell text look bigger. That should eliminate the problem without changing zoom every dropdown.