ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Compatibility Checker causing headaches (https://www.excelbanter.com/excel-programming/392358-compatibility-checker-causing-headaches.html)

Brian

Compatibility Checker causing headaches
 
Can anyone tell me (PLEASE!) if and how it is possible to get Excel to stop
popping up the compatibility checker dialog box? I am writing a macro that
must run through a loop and save multiple files in 2003-07 format. But,
every time it tries to save a file, the dialog box pops up...kind of throwing
a kink in the whole "automation" process.


Carim

Compatibility Checker causing headaches
 
Hi,

The instruction
Application.DisplayAlerts = False
should do the job ...

HTH
Carim


Brian

Compatibility Checker causing headaches
 
Thank you so much!
This sounds like it will do the trick for me
Brian.

"Carim" wrote:

Hi,

The instruction
Application.DisplayAlerts = False
should do the job ...

HTH
Carim




All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com