prevent screen pop up

[kelly mort]

Hello All,
I want to stop excel from showing MsgBox when I double click on locked cells.
Thanks in advance.
Kelly

 

[ranman256]

try
Application.DisplayAlerts false

 

[kelly mort]

Where should I place it? I placed it in workbook open event but did not work

 

[Jaafar Tribak]

As far as I know, there is no way of preventing that protection alert from poping up .

I wrote a small dll some time ago to customize that popup or abort it .. you can take a look at this thread : https://www.mrexcel.com/forum/excel...uilt-protected-worksheet-warning-message.html

 

[Peter_SSs]

Hello All,
I want to stop excel from showing MsgBox when I double click on locked cells.
Thanks in advance.
Kelly

I think there are three separate options you could consider. One of these may suit you.

1. When you protect the sheet, remove the tick from allowing users to 'Select locked cells'

2. File -> Options -> Advanced -> Remove tick from 'Allow editing directly in cells' -> OK

3. Right-click the sheet name tab and choose 'View Code'. Paste the code below into to right hand pane that opens.

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

 

[kelly mort]

I think there are three separate options you could consider. One of these may suit you.

1. When you protect the sheet, remove the tick from allowing users to 'Select locked cells'

2. File -> Options -> Advanced -> Remove tick from 'Allow editing directly in cells' -> OK

3. Right-click the sheet name tab and choose 'View Code'. Paste the code below into to right hand pane that opens.

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

Okay 2 and 3 worked for me. Thanks .
Kelly

 

[Peter_SSs]

Okay 2 and 3 worked for me. Thanks .
Kelly

You are welcome.
Of course you shouldn't need both as either one would do the same job, but I assume that is what you meant anyway.
(Hopefully 1 'worked' too, but just didn't suit your circumstances)

 

[kelly mort]

As far as I know, there is no way of preventing that protection alert from poping up .

I wrote a small dll some time ago to customize that popup or abort it .. you can take a look at this thread : https://www.mrexcel.com/forum/excel...uilt-protected-worksheet-warning-message.html

Hello Jaafar,
I have downloaded and tested your dll workbook and it worked fine too. Thanks for it.
Kelly