DoubleClick Macro giving error on other computers

I have a complex sample logging workbook. There are some locked cells and a before doubleclick vba code to insert date and name. I have the following code which allows the code to modify without unprotecting and reprotecting

Please Login or Register  to view this content.

Works fine when I do it. So I send it to someone else and they save it but when they do a double click, they get the typical "this cell is protected blah blah" Any thoughts on this?
Thanks in advance.

Dumb question:
Is Target on sheet LogIn?

Hey, always have to ask if it's plugged in first. Yes, it is worksheet "LogIn"

Second guess:
I think you need to set cancel = true for the before double click event.

If you aren't doing this, the code will work fine, but the double-click uncancelled will then try to edit the target cell.

I can imagine this would vary according to whether users have 'allow editing in cell' switched on or off. This would explain 'erratic' behaviour for you. Which I could test, I suppose.

I can confirm, because it wasn't that hard to test, that if 'Allow editing directly in cell' is switched on, you need to cancel the double click in the event macro. It's no surprise that you have it switched off CB!

Call me Sherlock.

Thank you Charlie. I will confirm with my test subject and close this thread.