| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
avoid warning when removing sheet
I want to remove all sheets except of sheet 1 by a macro
iSheetMax = Sheets.Count ' Delete other sheets For iSheet = 2 To iSheetMax Sheets(2 + iSheetMax - iSheet).Delete Next Then the user gets a warning message (warns for permanently deleting of sheet). I do not want this. How can I prevent the warning message to appear? Thanks, Tijmen |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
avoid warning when removing sheet
like this I suppose: iSheetMax = Sheets.Count ' Delete other sheets application.DisplayAlerts =False For iSheet = 2 To iSheetMax Sheets(2 + iSheetMax - iSheet).Delete Next application.DisplayAlerts =true |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
avoid warning when removing sheet
Hi Tijimen.
Try: iSheetMax = Sheets.Count Application.DisplayAlerts = False ' Delete other sheets For iSheet = 2 To iSheetMax Sheets(2 + iSheetMax - iSheet).Delete Next Application.DisplayAlerts = True --- Regards, Norman "Tijmen" wrote in message ... I want to remove all sheets except of sheet 1 by a macro iSheetMax = Sheets.Count ' Delete other sheets For iSheet = 2 To iSheetMax Sheets(2 + iSheetMax - iSheet).Delete Next Then the user gets a warning message (warns for permanently deleting of sheet). I do not want this. How can I prevent the warning message to appear? Thanks, Tijmen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing sending mail warning | Excel Worksheet Functions | |||
| How to I Avoid the Auto-Email Security Warning | Excel Programming | |||
| Removing Outlook Warning Dialogs. | Excel Programming | |||
| Removing Outlook Warning Dialogs. | Excel Programming | |||
Hybrid Mode
