| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppressing questions in Excel Macros
How does one suppress dialog that appears when executing a macro in Excel
2003. For example, a question such as "Do You Want To Save...". I have tried statements such as Application.CommandBar.... and Workbook.Command... , but they don't work. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Suppressing questions in Excel Macros
Try this. Hope this helps! If so, let me know, click "YES" below.
Application.DisplayAlerts = False ' your code here Application.DisplayAlerts = True -- Cheers, Ryan "danfw" wrote: How does one suppress dialog that appears when executing a macro in Excel 2003. For example, a question such as "Do You Want To Save...". I have tried statements such as Application.CommandBar.... and Workbook.Command... , but they don't work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suppressing the Disable/Enable Macros Message Box Programmatically | Excel Programming | |||
| Two questions, how do I disable ver 4 macros and how do I make radial buttons like this? | Excel Discussion (Misc queries) | |||
| Two questions, how do I disable ver 4 macros and how do I make radial buttons like this? | Excel Worksheet Functions | |||
| New Questions about Recording Macros | Excel Worksheet Functions | |||
| Suppressing Enable Macros QUestion | Excel Programming | |||
Linear Mode
