Macro not to check compatibility when saving this workbook

F

fruitchunk

I recorded a macro in excel, it works fine but stops by "Compatibility
Checker".
Can I have it in the macro "not to check compatibility when saving this
workbook", I don't want to disable the Compatibility Checker completely in
excel only in this macro.
Please help.
 
R

Ron de Bruin

Use this in 2007 and up and like Patrick told you stay in your first thread

ThisWorkbook.CheckCompatibility = False
ThisWorkbook.Save
 

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

Similar Threads

Difficulty with compatibility mode and Track Changes 2
Macro "not to check compatibility when saving this workbook" 4
Macro not to check compatibility when saving this workbook 2
2007 Compatibility Checker states cells outside of range when saving2003 version 0
Need Help with Macro Security 1
Setting column width in a table with a macro is not working 0
Menu Macro Not Executing - Need Help 1
2007: CheckCompatibility not honored 2

Top