How do I get rid of alerts?

  • Thread starter Thread starter Kenji
  • Start date Start date
K

Kenji

I want to delete a sheet using macros and simply doing
sheets("temp").delete

however, the user gets an "are you sure" box. Is there a way to get rid of
this alert box without using application.displayalerts? The
application.displayalerts does not work when the excel sheet is loaded on
ie. Thanks!

Kenji
 
Hi
try
Application.displayalerts = false
sheets("temp").delete
Application.displayalerts = True
 
Back
Top