Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove Worksheet using Sh.Delete without prompt
Can I remove a worksheet using a VBA function:
For example: Sheet1.Delete WITHOUT PROMPTING the user with this message: "Data may exist in the sheet(s) selected for deletion. to permanently delete the data, press Delete. " Thanks Coco ps. I know that this Sheet1 has data. Moreover, it is not important in this case. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove Worksheet using Sh.Delete without prompt
Hi Coco,
coco wrote: Can I remove a worksheet using a VBA function: For example: Sheet1.Delete WITHOUT PROMPTING the user with this message: "Data may exist in the sheet(s) selected for deletion. to permanently delete the data, press Delete. " You can use the DisplayAlerts property: Application.DisplayAlerts=False Sheet1.Delete Application.DisplayAlerts=True -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove Worksheet using Sh.Delete without prompt
One way:
Application.DisplayAlerts = False Sheet1.Delete Application.DisplayAlerts = True In article , "coco" wrote: Can I remove a worksheet using a VBA function: For example: Sheet1.Delete WITHOUT PROMPTING the user with this message: "Data may exist in the sheet(s) selected for deletion. to permanently delete the data, press Delete. " Thanks Coco ps. I know that this Sheet1 has data. Moreover, it is not important in this case. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove Worksheet using Sh.Delete without prompt
It works!!!
Thanks you Coco "JE McGimpsey" wrote: One way: Application.DisplayAlerts = False Sheet1.Delete Application.DisplayAlerts = True In article , "coco" wrote: Can I remove a worksheet using a VBA function: For example: Sheet1.Delete WITHOUT PROMPTING the user with this message: "Data may exist in the sheet(s) selected for deletion. to permanently delete the data, press Delete. " Thanks Coco ps. I know that this Sheet1 has data. Moreover, it is not important in this case. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove a query prompt in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I delete or remove additional blank pages of a worksheet? | Excel Worksheet Functions | |||
Remove read only prompt | Excel Discussion (Misc queries) | |||
remove enable macro prompt | Excel Discussion (Misc queries) | |||
Delete sheet without prompt | Excel Programming |