| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to write a marco in Excel to delete worksheet?
Dear Friends, Do you know how to write a marco in Excel to delete worksheet automatically, without prompting me to click OK? I have tried one by using the command: Sheets("Sheet2").Delete but it will ask me to click OK before delete it. It looks not professional. Thanks a lot. -- ko06879 ------------------------------------------------------------------------ ko06879's Profile: http://www.excelforum.com/member.php...o&userid=34149 View this thread: http://www.excelforum.com/showthread...hreadid=539188 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to write a marco in Excel to delete worksheet?
Hello
Application.DisplayAlerts = False Sheets("Sheet2").Delete Application.DisplayAlerts = True HTH Cordially Pascal "ko06879" a écrit dans le message de news: ... Dear Friends, Do you know how to write a marco in Excel to delete worksheet automatically, without prompting me to click OK? I have tried one by using the command: Sheets("Sheet2").Delete but it will ask me to click OK before delete it. It looks not professional. Thanks a lot. -- ko06879 ------------------------------------------------------------------------ ko06879's Profile: http://www.excelforum.com/member.php...o&userid=34149 View this thread: http://www.excelforum.com/showthread...hreadid=539188 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Marco to Delete Worksheets | Excel Discussion (Misc queries) | |||
| Using a Macro to Write A Marco | Excel Programming | |||
| A Marco Delete Question | Excel Programming | |||
| help.. want write a simple marco | Excel Programming | |||
| write marco to put data from sheet to memory | Excel Programming | |||
Linear Mode
