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
|