Double click on locked cell unlocks sheet

[lonybrown]

I have a password protected sheet. When you double click on a unlocked cell and then press entre the sheet unlocks (no password required).
How can I prevent the sheet from unlocking this way?

 

[Michael M]

Do you you have any macros in the workbook that afeect that sheet...I cannot replicate the issue you are getting

 

[Jeffrey Mahoney]

Do you have a macro? Because that is not usually possible

 

[lonybrown]

Do you you have any macros in the workbook that afeect that sheet...I cannot replicate the issue you are getting

No just a VBA

 

[lonybrown]

Do you have a macro? Because that is not usually possible

No Just a VBA

 

[Jeffrey Mahoney]

VBA is macros. Look in the Sheet Module and see if there is any code

 

[lonybrown]

VBA is macros. Look in the Sheet Module and see if there is any code
View attachment 49559

Sorry yes there is a code

 

[Jeffrey Mahoney]

Please post that code. it will probably be in a SUB like this

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

End Sub

 

[lonybrown]

Please post that code. it will probably be in a SUB like this

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

End Sub

Right at the bottom?

 

[Michael M]

Please post ANY code that is in that Sheet module ??