Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the following macro to delete worksheets in my workbook.
Sub Deleteworksheets() Sheets("Current Asset").Select ActiveWindow.SelectedSheets.Delete Sheets("Current Liability").Select ActiveWindow.SelectedSheets.Delete Sheets("Long Term Asset").Select ActiveWindow.SelectedSheets.Delete Sheets("Long Term Liability").Select ActiveWindow.SelectedSheets.Delete End Sub The obstacle I am having is that before each sheet deletes I am getting a message box that reads €śData may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete.€ť I would like to adjust the macro I have so that it will override this message box and delete the sheets I have indicated that I want to delete without checking if it is okay. Could you advise me on how I might do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA to delete worksheets | Excel Discussion (Misc queries) | |||
Delete All Worksheets, Except for Three | Excel Programming | |||
I can't delete my worksheets | Excel Discussion (Misc queries) | |||
I can't delete my worksheets | Excel Programming | |||
Delete worksheets | Excel Programming |