If it has a macro in it and you want to save it as a 2007/2010 file type, it's going to have to be a .xlsm extension, not a .xlsx.

Get rid of all the xxx.Select ... Selection.yyy. Use xxx.yyy

For example: Cells.Select + Selection.AutoFilter = Cells.AutoFilter


Regards, TMS