Hi Walter,

Am Thu, 31 Jul 2014 16:24:37 +0100 schrieb Walter Briscoe:

Public Sub auto_open()
Application.Run "PERSONAL.XLS!CheckDateConsistency"
End Sub
"PERSONAL!CheckDateConsistency" fails, 2003 does not type default.
2010 prefers to have macros in .xlsm files.
I can probably cope with the default file type being .xlsm, but the
default file type is .xlsx.

in xl2010 the personal macro workbook in named
PERSONAL.xlsb
Open Excel2010 = Record Macro = Save it in personal macro workbook =
Cancel
Now your PERSONAL.xlsb is created.
Paste your Auto_Open macro into a module of the PERSONAL.xlsb and call
it with
Public Sub auto_open()
Application.Run "PERSONAL.XLSB!CheckDateConsistency"
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional