Unlocked Cell To Allow Mouse Selection (click) Yet Deny Value Editing?

[Ark68]

OK, here's another "is it possible" question.

I have a protected worksheet set that only unlocked cells can be selected.
With that worksheet, the majority of cells are locked (to prevent the user from clicking all over the place). A few cells and ranges are unlocked. The user is encouraged, and expected to click on these cells.
For the most part, I do not want the user to edit the contents of the unlocked cells (which would suggest I need them locked), however, I want to execute a macro when the user clicks ? double clicks on that unlocked cell.

I haven't tried it yet, maybe the mouseclick (?) event will trigger before allowing the cell to enter editing mode. But if not, is what I want to do doable? ie keep a cell selectable for clicking with the mouse yet preventing the contents from being edited?

 

[CountTepes]

You can allow selection of protected cells on a protected sheet, but with the cell locked, you cannot edit the cell.

 

[Ark68]

Thank you CountTepes. With experimentation I discovered that clicking on an unlocked cell when Worksheet_BeforeDoubleClick event has been written will execute the code before allowing the user to edit tat cell's contents. I figure in the BeforeDoubleClick code one could lock that cell and carry on executing the code if editing the cell contents isn't permitted. KKeep the cell unlocked only long enough to accept a double click.

 

[Fluff]

Why not use a BeforeRightClick event rather than a DoubleClick event?

 

[Jaafar Tribak]

Thank you CountTepes. With experimentation I discovered that clicking on an unlocked cell when Worksheet_BeforeDoubleClick event has been written will execute the code before allowing the user to edit tat cell's contents. I figure in the BeforeDoubleClick code one could lock that cell and carry on executing the code if editing the cell contents isn't permitted. KKeep the cell unlocked only long enough to accept a double click.

Have you considered setting the Cancel argument in the Worksheet_BeforeDoubleClick event handler to prevent editing the cell ?