| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No message box displayed
Hello. I am running a macro that save my files in Excel 4 format after
doing what have to be done ( I have more then 50 files). However, Excel is always warning me that the file that i want to save is in Excel 4 format and I always need to press the ok button. I am sure that there is a way for me to tell Excel that I do not want any message displayed (that will necessitate my intervention) when the macro is running. Can you please help me out? Thanks for your help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No message box displayed
Untested:
application.displayalerts = false 'your code to save as xl4 application.displayalerts = true Marc wrote: Hello. I am running a macro that save my files in Excel 4 format after doing what have to be done ( I have more then 50 files). However, Excel is always warning me that the file that i want to save is in Excel 4 format and I always need to press the ok button. I am sure that there is a way for me to tell Excel that I do not want any message displayed (that will necessitate my intervention) when the macro is running. Can you please help me out? Thanks for your help! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check box and and formula | Excel Discussion (Misc queries) | |||
| Calculations And Order In Macros | Excel Discussion (Misc queries) | |||
| when opening excel I receive a message that says file can't be fo. | Excel Discussion (Misc queries) | |||
| changing the message in an error message | Excel Worksheet Functions | |||
| Pivot Table not valid error message when formatting data 'button'. | Excel Discussion (Misc queries) | |||
Hybrid Mode
