Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Worksheet - No Confirmations ?
How do I delete a worksheet without getting the confirmation message:
"Are you sure you wish to delete this worksheet?" Application.ActiveWorkbook.Sheets(3).Delete Lance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Worksheet - No Confirmations ?
Lance
Precede the code with Application.DisplayAlerts = False -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... How do I delete a worksheet without getting the confirmation message: "Are you sure you wish to delete this worksheet?" Application.ActiveWorkbook.Sheets(3).Delete Lance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Worksheet - No Confirmations ?
Application.DisplayAlerts = False
Application.ActiveWorkbook.Sheets(3).Delete Application.DisplayAlerts = True -- Regards, Peo Sjoblom wrote in message ... How do I delete a worksheet without getting the confirmation message: "Are you sure you wish to delete this worksheet?" Application.ActiveWorkbook.Sheets(3).Delete Lance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Worksheet - No Confirmations ?
Application.DisplayAlerts = False
Application.ActiveWorkbook.Sheets(3).Delete Application.DisplayAlerts = True HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- How do I delete a worksheet without getting the confirmation message: "Are you sure you wish to delete this worksheet?" Application.ActiveWorkbook.Sheets(3).Delete Lance |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Worksheet - No Confirmations ?
Hi Lance, this should do ya...
Application.DisplayAlerts = False Application.DisplayAlerts = True Above and below you code... seeya ste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting of worksheet | Excel Discussion (Misc queries) | |||
Deleting a worksheet but retaining values from the worksheet. | Excel Discussion (Misc queries) | |||
Deleting a worksheet but retaining values from the worksheet. | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
deleting worksheet | Excel Discussion (Misc queries) |