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 |