Prompt password when edit the cell

Hi

I have a macro that locks the cell (cell rangeis given) after entering data into cell & thereafter if we have tochange the value of cell it asks for password. It works well.

I want somechanges in this macro - currently if I move cursor on locked cell then alsoit prompt for password & i want if i edit that cell by double click or F2then only he ask for password.

Thanks in Advance !!!

Please Login or Register  to view this content.

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

End Sub

Thanks for reply...

I am very new to Vb & i dont have much knowledge of VB. Can you just make correction in above code so that i can just copy & paste the code.

Id look at what the code you have posted is doing, then apply that in the event i mentioned. Do you not understand what you alerady have?

I have copied that code ( event) into vb code but nothing happens....Shall I replace the first line with new sent by you.

I have checked with code its working....but if i pressed F2 to edit the cell then it not prompt for password. Is there any solutions?