| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing confirmation POP from excel
Hi Joel
Can we do the same without giving the sheet name? "Joel" wrote: Application.DisplayAlerts = False Worksheets("Sheet3").Delete Application.DisplayAlerts = True "singh" wrote: Hi All In one of my macro i have provided code for deleting a particular sheet. In between a pop up appears asking for confirmation for delete or cancel the sheet. Is there any way we can remove this prompt? I tried Application.DisplayAlerts = False. this thing is not proper for this. Thanks in Advance/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing confirmation POP from excel | Excel Programming | |||
| Confirmation box | Excel Programming | |||
| Confirmation ID provided? | New Users to Excel | |||
| Getting rid of confirmation boxes | New Users to Excel | |||
| Saving an Excel worksheet without getting the confirmation box | Excel Programming | |||
Linear Mode
