If I set CheckCompatibility to false on a workbook in a macro, and then do a SaveAs to downrev it to, say, Excel 2003 format, the
compatibility checker still runs...which is annoying.

How do I get Excel to NOT run the compatibility checker when saving files to earlier version from within a macro?

- Mark

Try this,

Set DisplayAlerts Property to false before your code for saving & set to
true afterwards


Application.DisplayAlerts = False
'codes for saving the workbook
Application.DisplayAlerts = True


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.




"Mark Olbert" wrote in message
...
If I set CheckCompatibility to false on a workbook in a macro, and then do
a SaveAs to downrev it to, say, Excel 2003 format, the
compatibility checker still runs...which is annoying.

How do I get Excel to NOT run the compatibility checker when saving files
to earlier version from within a macro?

- Mark

That did it. Thanks!

- Mark

On Sun, 15 Jul 2007 14:28:37 +0530, "shah shailesh" wrote:

Try this,

Set DisplayAlerts Property to false before your code for saving & set to
true afterwards


Application.DisplayAlerts = False
'codes for saving the workbook
Application.DisplayAlerts = True


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.




"Mark Olbert" wrote in message
.. .
If I set CheckCompatibility to false on a workbook in a macro, and then do
a SaveAs to downrev it to, say, Excel 2003 format, the
compatibility checker still runs...which is annoying.

How do I get Excel to NOT run the compatibility checker when saving files
to earlier version from within a macro?

- Mark