How do I override a deletion box?
 

This is the message I receive.

Data may exists in sheet(s) selected for deletion. To permantel
delete the data press delete.

The macro stops the loop process for this question with every build.
need it to be deleted automatically and build the next one.

Thank you :confused

--
DMueh
-----------------------------------------------------------------------
DMuehl's Profile: http://www.excelforum.com/member.php...fo&userid=1487
View this thread: http://www.excelforum.com/showthread.php?threadid=26504

How do I override a deletion box?
 

hi,
try add something like this:
Application.DisplayAlerts = False
Worksheets("Report").Delete
Application.DisplayAlerts = True

-----Original Message-----

This is the message I receive.

Data may exists in sheet(s) selected for deletion. To
permantely
delete the data press delete.

The macro stops the loop process for this question with
every build. I
need it to be deleted automatically and build the next
one.

Thank you :confused:


--
DMuehl
----------------------------------------------------------
--------------
DMuehl's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14877
View this thread:
http://www.excelforum.com/showthread...hreadid=265046

.

How do I override a deletion box?
 

Try this:

Application.DisplayAlerts = False

' Your code

Application.DisplayAlerts = True


"DMuehl" wrote:


This is the message I receive.

Data may exists in sheet(s) selected for deletion. To permantely
delete the data press delete.

The macro stops the loop process for this question with every build. I
need it to be deleted automatically and build the next one.

Thank you :confused:


--
DMuehl
------------------------------------------------------------------------
DMuehl's Profile: http://www.excelforum.com/member.php...o&userid=14877
View this thread: http://www.excelforum.com/showthread...hreadid=265046