Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multi[le file operation
Hi,
Guys you are genuises and always helped me. I hope that you can help me this time as well. Here is my problem: I have about 160 files that i run my macro for. part of the macro deletes 1 specific sheet. But before deleting the sheet it gives me a warning message that asks if i'm sure i want to delete it. I have to press "enter" key 160 times for all the files. Is there a way to put that "enter" stroke in the code? Thank you Igor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multi[le file operation
Application.DisplayAlerts = False
ActiveSheet.Delete Application.DisplayAlerts = True Use this Igor -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "igor" wrote in message ... Hi, Guys you are genuises and always helped me. I hope that you can help me this time as well. Here is my problem: I have about 160 files that i run my macro for. part of the macro deletes 1 specific sheet. But before deleting the sheet it gives me a warning message that asks if i'm sure i want to delete it. I have to press "enter" key 160 times for all the files. Is there a way to put that "enter" stroke in the code? Thank you Igor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
multi[le file operation
application.displayalerts=false
reset to =true when finished -- Don Guillett SalesAid Software Granite Shoals, TX "igor" wrote in message ... Hi, Guys you are genuises and always helped me. I hope that you can help me this time as well. Here is my problem: I have about 160 files that i run my macro for. part of the macro deletes 1 specific sheet. But before deleting the sheet it gives me a warning message that asks if i'm sure i want to delete it. I have to press "enter" key 160 times for all the files. Is there a way to put that "enter" stroke in the code? Thank you Igor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find a value with multi-column, multi-record list | Excel Worksheet Functions | |||
need to save multi lingual content from an Excel file to a CSV fil | Excel Discussion (Misc queries) | |||
Importing file with fixed width, multi-line records | Excel Discussion (Misc queries) | |||
Publishing an excel file on Sharepoint for multi-editing | Excel Discussion (Misc queries) | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |