Macro names changed in V2007

[Ruckley]

Hi.

I have a workbook that I built in Excel V2003. It seems to work fine in V2007 but some students have had problems after saving it as a Macro Enabled Workbook file.

It doesn't seem to recognise the names of some of the macros thereafter.

Any ideas why?

Thanks.

:whistle:

[Bob Phillips]

Give us some examples.

[Kenneth Hobs]

Not sure if this happened but if you have a named range which also has the same cell address, in 2003 and open in a newer version, Excel will rename those named ranges for you. Your VBA code that used those names will then need modification.