View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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