Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Error Resume Next
Application.Displayalerts = False Sheets("Bakery").Delete Applicaton.displayAlerts = True On Error goto 0 -- Regards, Tom Ogilvy "M Shannon" wrote in message ... I have this macro on close: Sheets("Bakery").Select ActiveWindow.SelectedSheets.Delete I need to do two things. 1) If the sheet doesn't exist I want the macro to do nothing and carry on to delete the next worksheet. 2) If the sheet does exist I want the macro to delete it without the warning. Any help is much appreciated. Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Warning Message | Excel Discussion (Misc queries) | |||
Macro Warning Message | Excel Discussion (Misc queries) | |||
Stoping the Macro Warning Message | Excel Discussion (Misc queries) | |||
Warning message on file close | Excel Worksheet Functions | |||
Code & modules are gone, Macro warning message remains | Excel Programming |