By default, double-clicking edits the cell. Editing a cell is a user's action, and it is forbidden with a protected sheet. The BeforeDoubleClick event is dispatched when you double-click but before the cell is edited. At this point, the code is being executed, which by using UserInterfaceOnly = True can be executed without any problems (not always, but let's skip this problem). After the execution is finished, an attempt is made to edit the cell, which is already not allowed in the case of a protected sheet.
A fairly common error. Developers forget to disable the default behavior. Just after
add
Artik
Bookmarks