Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Excel Macro Delete function!!
I use the following command in the Excel Macro to delete an Exce
worksheet called "Report": Sheets("Report").Delete However when I run the macro, the user will be prompted if th worksheet "Report" should be deleted. I do not want user to be asked. Instead I want the worksheet "Report to be deleted automatically. Can anyone please advise if there is a command to "force" delete th worksheet without asking the confirmation from user? Million Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Excel Macro Delete function!!
I do not want user to be asked. Instead I want the worksheet "Report"
to be deleted automatically. Can anyone please advise if there is a command to "force" delete the worksheet without asking the confirmation from user? Application.DisplayAlerts = False Worksheets("Report").Delete Application.DisplayAlerts = True HTH, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Excel Macro Delete function!!
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Excel Macro Delete function!!
wmcray wrote:
I use the following command in the Excel Macro to delete an Excel worksheet called "Report": Sheets("Report").Delete However when I run the macro, the user will be prompted if the worksheet "Report" should be deleted. I do not want user to be asked. Instead I want the worksheet "Report" to be deleted automatically. Can anyone please advise if there is a command to "force" delete the worksheet without asking the confirmation from user? Million Thanks --- Message posted from http://www.ExcelForum.com/ Start every macro with With Application .Calculation = xlCalculationManual .ScreenUpdating = False .DisplayAlerts = False End With and end with With Application .Calculation = xlCalculationAutomatic .ScreenUpdating = True .DisplayAlerts = True End With -- Amedee Van Gasse using XanaNews 1.16.3.1 If it has an "X" in the name, it must be Linux? Please don't thank me in advance. Thank me afterwards if it works or hit me in the face if it doesn't. ;-) PS: I found 2 small shortcomings on www.excelforum.com: 1. You do *not* have to pay for access to news:msnews.microsoft.com 2. A *real* newsreader (not Outlook Express) is actually very easy to use. See www.newsreaders.com for more info. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Delete VB Macro | Excel Worksheet Functions | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
Excel Problem - Delete Row Macro | Excel Programming | |||
Delete records using excel Macro | Excel Programming | |||
Delete records using excel Macro | Excel Programming |