Macro not to check compatibility when saving this workbook

  • Thread starter Thread starter fruitchunk
  • Start date Start date
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.
 
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

Macro "not to check compatibility when saving this workbook" 4
Macro not to check compatibility when saving this workbook 2
Compatability Checker Question 3
2007: CheckCompatibility not honored 2
checkcompatibility not working in Windows 7 4
How to conditionally determine Workbook save compatibility in VBA? 1
How to avoid Compatibility Checker MsgBox? VBA to avoid or prevent? 1
Lose macros before saving 4

Back
Top