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