Turning off System Messages

[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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[John Wilson]

Bruce,

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

John

 

[Bruce B]

Thanks John!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!