Macros: 2007 and 1997-2003 incompatibility

[lemonstar]

I've just found that the macros I recorded in 2007 for a simple data sort, i.e. highlight some cells and data sort, do not run when the spreadsheet is opened in Excel 1997-2003 after the original had been saved in the old format.There was a warning about slight loss of quality due to formatting but nothing else. Is there a simple way around this or do I have to rerecord all the macros in the old version?

Macros code for the sort is typically this:-

Please Login or Register  to view this content.

[VBA Noob]

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Move to programming.

Please Login or Register  to view this content.

is a xl 2007 command I believe. Best to make the macro's in xl 03 whenever possible

VBA Noob