Application.DisplayAlerts = False Does not work

0 Agios

0 Agios

Well-known Member
Joined
Feb 22, 2004
Messages
570
Office Version
  1. 365
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
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
What alert are you trying to stop being displaye?
 
Upvote 0
Norie said:
What alert are you trying to stop being displaye?
Click to expand...
there are 2 alert boxes that popup, one with copy, paste etc and one with the fonts. Just like if you right click on any page. Thank you
 
Upvote 0
Not sure what you mean by 'one with the fonts' but you might get rid of the copy/paste one using this.
VBA Code: 
Application.CutCopyMode = False
 
Upvote 0
Are the alert boxes you are seeing coming from Excel?
 
Upvote 0
Can you post an image of what you are getting?
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Excel Export to PDF Font Size and Style
Replies
5
Views
115
jolivanes
jolivanes
C
  • Solved
Run-time error '-2147319767 (80028029)
Replies
2
Views
680
CaptainGravyBum
C
C
  • Solved
Message box appearing twice when closing workbook
Replies
3
Views
253
Alex Blakenburg
A
M
  • Question
Clipboard error when copying shape
Replies
4
Views
329
marc81
M
C
  • Solved
Macro works for one file, does not work for all files in the directory
2
Replies
13
Views
435
Alex Blakenburg
A

Forum statistics

Threads
1,214,391
Messages
6,119,247
Members
448,879
Latest member
oksanana

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top