PDA

View Full Version : Solved: Eliminating the "Data May Exist in the Sheets Selected for deletion" window



mferrisi
04-05-2007, 12:27 PM
I created a macro that imports data from a database. In the macro, I delete the page that the data was on, and each time get a popup window that reads, "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press delete."

Is there a way to permanently delete the data in the code? (If I use 'clear contents" i get the same popup.)

Thank you

lucas
04-05-2007, 12:34 PM
You really should post the code your using.....
You might try this:
Application.DisplayAlerts = False
'your code
'Don't forget to reset application.DisplayAlerts to True
Application.DisplayAlerts = True