Turning off System Messages

  • Thread starter Thread starter Bruce B
  • Start date Start date
B

Bruce B

I have a line of code (excel 2000) that deletes a sheet. When it runs a
system message pops up and asks if I really want to delete the sheet.

Is there any way that I can turn this system message off?

Thanks!

- Bruce
 
Bruce,

Just prior to that line of code to delete the sheet:
Application.DisplayAlerts = False
and right after it
Application.DisplayAlerts = True

John
 
Back
Top