How do i turn OFF compatibility checker



I am trying to automate a process that requires me to save files with
different names. But, every time my macro goes to save a file the
compatibility checker dialog box pops up.

It is only for minor formatting issues but it has more than 70 instances and
gives me no way of finding out which cells are the culprits.

Can I make Excel automatically save the file without popping up this
annoying dialog box?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question