| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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  -- DMuehl ---------------------------------------------------------- -------------- DMuehl's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=14877 View this thread: http://www.excelforum.com/showthread...hreadid=265046 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 -- DMuehl ------------------------------------------------------------------------ DMuehl's Profile: http://www.excelforum.com/member.php...o&userid=14877 View this thread: http://www.excelforum.com/showthread...hreadid=265046 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If/Vlookup override | Excel Worksheet Functions | |||
| Need help to freeze or override a formula | Excel Discussion (Misc queries) | |||
| Override a Formula | Excel Discussion (Misc queries) | |||
| Override save as Dialog box | Excel Worksheet Functions | |||
| Cell Value Override | Excel Discussion (Misc queries) | |||
Linear Mode
