| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete method
Does anyone know how to stop the delete method from prompting the user when
you use it to delete a chart sheet. I'm using it to delete multiple sheets and it get annoying to have to press enter repeatedly |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete method
Hi,
Try Application.DisplayAlerts =False Regards, sebastien "chessley" wrote: Does anyone know how to stop the delete method from prompting the user when you use it to delete a chart sheet. I'm using it to delete multiple sheets and it get annoying to have to press enter repeatedly |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete method
Chessley,
Sub byebye() Application.DisplayAlerts = False ThisWorkbook.Charts("Chart1").Delete Application.DisplayAlerts = True End Sub where "Chart1" is the chart you are deleting, with this method always make sure to turn Alerts Back on using Application.DisplayAlerts = True "chessley" wrote: Does anyone know how to stop the delete method from prompting the user when you use it to delete a chart sheet. I'm using it to delete multiple sheets and it get annoying to have to press enter repeatedly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative copy/delete method needed | Excel Discussion (Misc queries) | |||
| Delete method of Range class failed - HELP!!! | Excel Programming | |||
| Range.delete method | Excel Programming | |||
| runtime error '1004' delete Method of Range Class Failed | Excel Programming | |||
Hybrid Mode
