Suppress Protection Prompt

[neodjandre]

Is there a macro to supress the popup prompt saying "the cell is protected...." when users double click on a protected cell ?

i prefer for nothing to happen when users double click a protected cell..

 

[Norie]

How about this?

Cancel = Target.HasFormula

 

[neodjandre]

that seems to work the best norie.. thanks !