Tag: Excel 2007
-
VBA automatically saves Excel 2003 Workbook in compatibility mode as Excel 2007 Workbook
Lets say you have a neat little Excel 2003 macro, when you run your macro in Excel 2007, Excel runs it in Compatibility Mode, and any benefits (such as the 16384 columns) you were hoping to use are still unavailable. So how can we enable these benefits depending on the Excel version? Simply by including…