Select a protected cell

[philR]

Is it possible to protect a cell against being altered, but still allow the user to select it and double click it?

Must be on here somewhere but I cant find it.

Many thanks

 

[6StringJazzer]

You can allow the user to select it like this: Make sure the cell is locked, then protect the sheet, and check the option to Select locked cells. But a double-click opens the cell for editing and editing a locked cell is never allowed; that is the whole point of a protected sheet.

If you are writing VBA, you can implement the Sub Worksheet_BeforeDoubleClick with

Cancel = True

to allow actions to occur on a double-click without editing the cell, and that will be allowed even on a locked cell.

 

[philR]

Perfect, thanks. When i did this and recorded it, it turns out the VBA code I was missing is:
Sheet1.EnableSelection = xlNoRestrictions

 

[6StringJazzer]

It would have been helpful to note in your first post that this was a VBA question. Glad you got it solved.

 

[philR]

It would have been helpful to note in your first post that this was a VBA question. Glad you got it solved.

Oops, I thought I had! Ha ha! My bad. Thanks for the help!