| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
to delete a worksheet
but want to ignore the warning message, please advise what should I
add at the end of the following command? thanks e.g. Sheets("ABC").Select Sheets("ABC").Delete Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
to delete a worksheet
Hi Paul
This will work, there is no need to select the sheet first. Sub tt() Application.DisplayAlerts = False Sheets("ABC").Delete Application.DisplayAlerts = True End Sub Regards Andrew Bourke ªü¤T wrote: but want to ignore the warning message, please advise what should I add at the end of the following command? thanks e.g. Sheets("ABC").Select Sheets("ABC").Delete Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
to delete a worksheet
Dear Andrew
Lots of thanks! Paul "Ajtb" ¼¶¼g©ó¶l¥ó·s»D ... Hi Paul This will work, there is no need to select the sheet first. Sub tt() Application.DisplayAlerts = False Sheets("ABC").Delete Application.DisplayAlerts = True End Sub Regards Andrew Bourke ªü¤T wrote: but want to ignore the warning message, please advise what should I add at the end of the following command? thanks e.g. Sheets("ABC").Select Sheets("ABC").Delete Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete value on worksheet 2 that match values on worksheet 1 | Excel Discussion (Misc queries) | |||
| How to delete a duplicate Excel worksheet within that worksheet? | Excel Discussion (Misc queries) | |||
| Delete a worksheet | Excel Discussion (Misc queries) | |||
| How do you delete a worksheet? | Excel Discussion (Misc queries) | |||
| Delete a Worksheet | Excel Programming | |||
![ªü¤T[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
