BeforeDoubleClick on Locked Cell

[rickincanada]

I have a need to display a user form using the BeforeDoubleClick Event in VBA. The problem I'm having is that the cell I want the user to double-click in is locked and the sheet is protected. I can make it work if the cell is unlocked or if the sheet is not protected however this puts the formula in there at risk of being changed.

Here is my VBA:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Target.Address = "$F$25:$G$25" Then
Call PriceRollback
End If

End Sub

Can anyone help me to do this without exposing this cell? Or is it even possible?

Thanks,
Rick

 

[JackDanIce]

Why not unlock and then lock before and after the Call line?

 

[rickincanada]

What am I missing:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Target.Address = "$F$25:$G$25" Then
Sheets("Deal Info").Select
Sheets("Deal Info").Unprotect ("password")
Range("$F$25:$G$25").Select
Selection.Locked = False
Call PriceRollback
Range("$F$25:$G$25").Select
Selection.Locked = True
Sheets("Deal Info").Protect ("password")
End If

End Sub

Still isn't working...sorry if I'm making this painful for you.

 

[RoryA]

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = Target.Locked
If Not Intersect(Target, Range("$F$25:$G$25")) Is Nothing Then
Call PriceRollback
End If

End Sub

Note that you need to allow the user to select unlocked cells (the default option)