| 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 | |||
Hybrid Mode
