Avoid Notification

[MikeDBMan]

I run a VBA macro that may delete a sheet within a file. Before I delete the sheet, I execute this line of code

Application.EnableEvents = False

Yet I still get this message:

"Data May Exist in the sheet(s) selected for deletion. To permanently delete the data press delete."

Suggestions?

 

[ChrisOswald]

try
application.setwarnings = false
followed later with
application.setwarnings = true

 

[VoG]

You need

Application.DisplayAlerts=False

 

[VoG]

try
application.setwarnings = false
followed later with
application.setwarnings = true

Does not exist.

 

[mole999]

application.DisplayAlerts = false

 

[ChrisOswald]

That's what I get for looking at Mr excel while I'm building stuff in Access.