| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
suppress warnings
Hi all
How can I suppress warnings like "selected sheet will be permanently deleted" while a macro deleting sheets is being run? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
suppress warnings
Hi
add the line application.displayalerts = false before the deletion code and the line application.displayalerts = True after the deletion -----Original Message----- Hi all How can I suppress warnings like "selected sheet will be permanently deleted" while a macro deleting sheets is being run? Thanks! . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
suppress warnings
Claude,
application.displayalerts = false your code application.displayalerts = true You might want to have a look at Google's group search feature which has answers like this archived. This one pops up a lot. Robin Hammond www.enhanceddatasystems.com "Claude" wrote in message ... Hi all How can I suppress warnings like "selected sheet will be permanently deleted" while a macro deleting sheets is being run? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| circular reference warnings | Excel Worksheet Functions | |||
| Warnings | Excel Discussion (Misc queries) | |||
| how to protect without getting the warnings | Excel Worksheet Functions | |||
| how to protect without getting the warnings | Excel Worksheet Functions | |||
| Turn off warnings in Macro | Excel Worksheet Functions | |||
Linear Mode
