| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Silencing Excel popup messages
In the process of running a particular macro I need to delete a worksheet in
the workbook so that it can be replaced. However, when doing this a popup message comes up asking if I'm sure I want to delete the page as there might be important information on it. Consequently it stops the macro until OK is pressed and is a hassle for my users. Is there a snippet I can add into my macro so this doesn't happen? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Silencing Excel popup messages
application.displayalerts = false should do it |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Silencing Excel popup messages
Application.DisplayAlerts = False
"James" wrote: In the process of running a particular macro I need to delete a worksheet in the workbook so that it can be replaced. However, when doing this a popup message comes up asking if I'm sure I want to delete the page as there might be important information on it. Consequently it stops the macro until OK is pressed and is a hassle for my users. Is there a snippet I can add into my macro so this doesn't happen? Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Silencing Excel popup messages
Thanks, worked great!
"ruff" wrote: application.displayalerts = false should do it |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Messages in Excel | Excel Discussion (Misc queries) | |||
| Excel POPUP | Excel Worksheet Functions | |||
| messages from excel -- to avoid | Excel Programming | |||
| Popup in excel | Excel Discussion (Misc queries) | |||
| Excel messages | Excel Programming | |||
Linear Mode
