Application.DisplayAlerts = False Does not work

[0 Agios]

I tried everything the copy paste etc form comes on after I close my form
I tried in work book, the form terminate etc it just continues

Private Sub UserForm_Deactivate()
Application.DisplayAlerts = False
End Sub

 

[0 Agios]

 

[0 Agios]

this happens when i close a vba form

 

[0 Agios]

they did nice work with this board i was posting when all this features did not exist

 

[0 Agios]

Can you post an image of what you are getting?

 

[0 Agios]

do you see the image?

 

[RoryA]

How are you triggering the userform? Using a worksheet event like BeforeRightClick or BeforeDoubleClick?

 

[0 Agios]

How are you triggering the userform? Using a worksheet event like BeforeRightClick or BeforeDoubleClick?

before right click, should i change it?

 

[RoryA]

You need to add:

Cancel = True

before the line that shows the form and that will prevent the popup menu from appearing.

 

[0 Agios]

Thank you it worked