Silencing Excel popup messages
 

In the process of running a particular macro I need to delete a worksheet in
the workbook so that it can be replaced. However, when doing this a popup
message comes up asking if I'm sure I want to delete the page as there might
be important information on it. Consequently it stops the macro until OK is
pressed and is a hassle for my users. Is there a snippet I can add into my
macro so this doesn't happen?

Thanks!

Silencing Excel popup messages
 

application.displayalerts = false

should do it

Silencing Excel popup messages
 

Application.DisplayAlerts = False

"James" wrote:

In the process of running a particular macro I need to delete a worksheet in
the workbook so that it can be replaced. However, when doing this a popup
message comes up asking if I'm sure I want to delete the page as there might
be important information on it. Consequently it stops the macro until OK is
pressed and is a hassle for my users. Is there a snippet I can add into my
macro so this doesn't happen?

Thanks!

Silencing Excel popup messages
 

Thanks, worked great!

"ruff" wrote:


application.displayalerts = false

should do it