| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
What is the VBA code to delete a sheet without warning message?
I have the following code to delete a tab:
Sheets("Sheet1").Select ActiveWindow.SelectedSheets.Delete When I run this, I get the standard "You may lose data" warning message. Does a different syntax allow me to delete the sheet without getting the warning message? Thanks |
|
#2
|
|||
|
|||
|
Application.DisplayAlerts = False Sheets("Your Sheet").Delete Application.DisplayAlerts = True HTH Dennis " wrote: I have the following code to delete a tab: Sheets("Sheet1").Select ActiveWindow.SelectedSheets.Delete When I run this, I get the standard "You may lose data" warning message. Does a different syntax allow me to delete the sheet without getting the warning message? Thanks |
|
#3
|
|||
|
|||
|
Thanks!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
| is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? | Excel Worksheet Functions | |||
| Highlighting | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
Hybrid Mode
