UserInterfaceOnly:=True not working?!?!

Hello everyone,

I would like to create a checklist that is not allowed to be changed.
The user has permission to add his own comments in column "F".
In column "G", the user's name and the date are automatically entered in the cell by double-clicking. The user should not be able to change any other cells.
For this, I call a macro in "Workbook_Open", which protects all pages.
Here I work with UserInterfaceOnly:=True -> Changes by macros should be allowed.

My macros work so far...
However, AFTER finishing the macros I always get the error: "The cell or chart you're trying to change is on a protected sheet."
As I said, the macros are executed normally. It looks to me like Excel is doing some kind of validation after the macros, which is causing this error.

I would be very grateful if someone could take a look at this.
You can test the whole thing by simply double-clicking in cell G23, for example.

Regards Michel

Thank you for your answer. I updated my profil.
Yes, I am using Microsoft Office Professional Plus 2016.
Regards

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

Please Login or Register  to view this content.

add

Please Login or Register  to view this content.

Artik

OMG!!!! IT IS WORKING!!!!!!
I spent more than two weeks here on this problem.
Asked once and solved in the first answer.
Thank you so much!!!

Originally Posted by tapete86

I spent more than two weeks here on this problem.

But it was not a waste of time. You will surely remember for a long time that you should turn off the default behavior in such cases. This is not just for the BeforeDoubleClick event. Whenever you encounter the Cancel parameter, pay attention to it. But that doesn't mean you should always set Cancel to True.

Artik