VBA Prevent Excel's Pop-ups

[Pinaceous]

Hi All,

How do I prevent Excel's Pop-ups from appearing on the screen.

For example, if one saves the document and

Their Pop-Up Appears, My question is there a way to restrict Excel's pop-up from popping up??

Please let me know!

Thank you!
pinaceous

 

[Pinaceous]

Sub Optimise()
On Error Resume Next
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
Application.DisplayStatusBar = False
Application.Calculation = xlCalculationManual
ActiveSheet.DisplayPageBreaks = False
changeflag = 0
On Error GoTo 0
End Sub

If in using this code, I'm getting an error on the

 changeflag = 0