How To Disable Compatibility Checker

[jstevens]

Does anyone know the navigation in Excel 2007 to disable the compatibility checker?

untitled.png

Thanks,
John

[rory]

I don't think there is a global setting.

[Jan Karel Pieterse]

I wouldn't know where they hid that checkbox.
#EDITED to add#:

Seems this is a workbook setting that can't be overridden globally.

[steveh]

Does anyone know the navigation in Excel 2007 to disable the compatibility checker?

untitled.png

Thanks,
John

Hi John

I am sure that you have already Googled but in case you missed these

http://www.excelguru.ca/node/105" onclick="window.open(this.href);return false;

From the Ken Puls website

Code: Select all

Private Sub App_WorkbookBeforeSave(ByVal Wb As Workbook, ByVal SaveAsUI As Boolean, Cancel As Boolean)
'Date Created : 9/24/2008 19:59
'Author       : Ken Puls (www.excelguru.ca)
'Macro Purpose: Disable compatibility checker

    Wb.CheckCompatibility = False

End Sub

HTH

[jstevens]

Thank you Steve.

Regards,
John