Macro not to check compatibility when saving this workbook
 

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.

Macro not to check compatibility when saving this workbook
 

see your earlier question. Please respond to THAT not THIS

thanks very much

"fruitchunk" wrote:

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.

Macro not to check compatibility when saving this workbook
 

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

ThisWorkbook.CheckCompatibility = False
ThisWorkbook.Save


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"fruitchunk" wrote in message ...
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.

Macro not to check compatibility when saving this workbook
 

Sorry, please disregard this post.

"fruitchunk" wrote:

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.