Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Delete a Sheet
How can I force Delete a Sheet without having a popup dialog?
I am currently doing this (ActiveWindow.SelectedSheets.Delete) Is there anyother way? Thank you in advance for your help... Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Delete a Sheet
Michael,
Use something like Application.DisplayAlerts = False ' delete the sheet Application.DisplayAlerts = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Michael Kintner" wrote in message ... How can I force Delete a Sheet without having a popup dialog? I am currently doing this (ActiveWindow.SelectedSheets.Delete) Is there anyother way? Thank you in advance for your help... Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Delete a Sheet
Sub test()
Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True End Sub Use Application.DisplayAlerts Michael -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Michael Kintner" wrote in message ... How can I force Delete a Sheet without having a popup dialog? I am currently doing this (ActiveWindow.SelectedSheets.Delete) Is there anyother way? Thank you in advance for your help... Mike |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Delete a Sheet
Mike, try this
Sub test() Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "Michael Kintner" wrote in message ... How can I force Delete a Sheet without having a popup dialog? I am currently doing this (ActiveWindow.SelectedSheets.Delete) Is there anyother way? Thank you in advance for your help... Mike |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Delete a Sheet
Hi Michael,
To supress the messagebox(es), you can use the DisplayAlerts property: Application.DisplayAlerts=False '/ delete sheet here Application.DisplayAlerts=True -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Michael Kintner wrote: How can I force Delete a Sheet without having a popup dialog? I am currently doing this (ActiveWindow.SelectedSheets.Delete) Is there anyother way? Thank you in advance for your help... Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete values in sheet 2 that arre found in sheet 1 | Excel Discussion (Misc queries) | |||
force users to enable macro so sheet cannot be printed | Excel Discussion (Misc queries) | |||
Force excel to open on a specific sheet | Excel Worksheet Functions | |||
How to force workbook to always open on the index sheet tab | Excel Worksheet Functions | |||
Must be a way to force focus back to sheet instead of UserForm - isn't there? | Excel Programming |