No message box displayed

M

Marc

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!
 
D

Dave Peterson

Untested:

application.displayalerts = false
'your code to save as xl4
application.displayalerts = true
 
Top