Allowing user to select a cell but not edit it?

**Falantar** · 08-25-2009, 11:39 AM

My situation:

I have an event handler that runs a procedure when a user double clicks a cell. This procedure modifies the contents of this cell and other cells. I want the user to be able to select the cell so they can double click it, but I don't want them to be able to single click it and modify it by hand (accidentally or not). Is there a way to lock/unlock the contents of the cell without locking the cell itself?

**shg** · 08-25-2009, 11:57 AM

Your version of Excel allows you to enable selection of locked cells. Look at the options under Protection.

**MickG** · 08-25-2009, 12:02 PM

Try this:-
Paste code at top of VB Window

Please Login or Register  to view this content.

Regards Mick

**Falantar** · 08-25-2009, 01:27 PM

Originally Posted by shg

Your version of Excel allows you to enable selection of locked cells. Look at the options under Protection.

Understood. However, I'm looking to avoid locked cells from being selected because this would only cause more problems. I'm not discounting it but I was hoping to find another way.

@Mick - I don't quite understand what purpose those 2 subs serve. I added them but nothing has changed.

**jaslake** · 08-25-2009, 09:25 PM

I'm not certain what you are trying to accomplish but the following code will allow the user to access "locked cells" but not modify them.

Add this code to your workbook open event:

Please Login or Register  to view this content.

The user will be allowed access to locked cells but not change them.

Hope this helps.

J

**MickG** · 08-26-2009, 05:49 AM

Hi,
This code should be in the Worksheet Module. Right click sheet tab , Select "View Code", VB Window appears , Paste code into window (At top)
If you make sure the Variable "temp" is at the top of the code Under "Option Explicit" (Which hopefully is at the top of your code page) then this variable is available to both the "Event Handlers".
The Selection Event passes the Target value to the variable "Temp". The "Change Event" then Places the "Temp" value back in the Target cell, so that whatever you try to change the Target cell to, It will always be its original Value.
Just an Idea, You'll probably need to restrict it to certain ranges.
Regards Mick