Disable notification when user clicks locked cell

[der_roedie]

Hello,

i've got the following problem:

I want users to double-click on a row on a protected sheet and then do some code based on the row-number of the clicked cell. I've protected the sheet because it contains a lot of formula's.

When a user double-clicks a row it triggers the code through the Workbook_SheetBeforeDoubleClick event.
After the code is executed Excel shows a message that the cell that was clicked was protected etc etc.

How can I prevent this message from popping up?

I've already tried

application.displaywarnings = false

but that didn't work

Thanks

 

[SephVd]

Greetings, VoG,

I have a similar question but in my case, I don't double-click! I try to enter a single character in a locked cell without getting the notification. How can I suppress the notification when entering a character in a locked cell (with a single click)?

I suggest that you may disable the Cell selection to prevent from typing on it. How to do it?

On the category "EnableSelection" change the value into "1 - x_____".


SephVD....

 

[SephVd]

Hello BBrite...

I suggest that you need to disable the Cell selection in locked cell.

How to do it?
On the category "EnableSelection", change the value to "1 - x_____". it's a drop down list.