Statement: "Application.DisplayAlerts = False" doesn't work for me

What seemed like an easy task turned into a very difficult one...so I decided to give up and turn to you guys...

Using Excel 2003, I have a lot of Subs and functions that call each other to generate a complete report. The flow goes as follows:
1- Menu Bar (that I've created) - click on a button that launches a Sub "Launch1"
2- Sub "Launch1" opens a Userform(progress bar)
3- Userform launches another sub "Start1"
4- Sub "Start1" calls many functions but in it, I have the following code:

Please Login or Register  to view this content.

Everything works in this particular macro but the message still pops up "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete".

How can I make that pop-up disappear (or automatically "accept" to delete).

Any help would be appreciated.

Thanks,

Alex

I've figured it out.

Looks like opening another workbook cancels Application.DisplayAlerts so I simply added the code again above Sheets("ABC").Delete

Turning alerts off like that should do the trick. Can you attach a sample workbook with it not working?

You also need to make sure you're turning alerts back on and include error handling that does so should the procedure not execute correctly.

Dom

Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.

Dom