Cannot Unprotect Sheet in a Worksheet_BeforeDoubleClick Macro

I have three column ranges on a sheet, each with list-based data validation. In order to change the zoom of 61 to a more readable 100 for purposes of choosing a selection from a validation drop-down, I have the following code in the sheet module. When the sheet is unprotected, toggling the zoom works perfectly. When the sheet is protected and a validation code double-clicked, the sheet does not unprotect and the code hangs until ESC is pressed. There is not password. I am stymied. Any hints or solutions will be greatly appreciated.

Please Login or Register  to view this content.

Thank you YasserKhalil. I took out ActiveSheet.Protect during testing. Will add line if I can get the Unprotect code working. I am going to set up a similar scenario in a new workbook to see if the code works there.

Excel Data Validation stops VBA code from running until selection is committed to the cell (code continues after).

I suspect protection stops validation from committing value to the cell and code hangs.

Try putting the code in standard module and assigning it to a short cut key and test if that works.

CK76, Thank you for your response and your insight! Intuitively, it made sense. To test I tried your suggestion to put code into a standard module but could not figure a way to assign a short cut key or to otherwise run code. Appears it must be run from a sheet module. I was able to test another way. To rule out any other possible conflicts in this complex workbook, I set up a new workbook and recreated a similar scenario with three columns, each with validation. The problem was replicated. I then removed validation on one column, uncommented the ActiveSheet.Protect code noted by YasserKhalil and double-click code runs perfectly when sheet is protected. So you are correct. Validation stops VBA code from running until selection is committed to the cell. NOW, is there a way to overcome this problem?

One way to do it. Put below in standard module.

Please Login or Register  to view this content.

Then assign it a short cut key. You can run code without double click via key combination.

Or assign it to "SelectionChange" event, instead of "BeforeDoubleClick".

See if one of the method works for you.