I have a problem, We have created a report that gives employees their stats
summary and objectives.
We created a macro, to copy the tab and lighten it so that it get rid of the
formulas, and makes it even more presentable.
The problem that we have is that when we were using Excel 2003 he macro
worked perfectly.
When our team switched to Excel 2007, but most of our customers still have
2003 the macro started giving errors. The macro execustes half way and then
gives the error message.
Could it be that because we have Excel 2007 and the macro is done in that
version, that our customers that uses Excel 2003 are not compatible.
Any help is appreciated

Could it be that because we have Excel 2007 and the macro is done in that
version, that our customers that uses Excel 2003 are not compatible.

Yes, if you use a property or method that is 2007 specific.

Post your code for more help.

HTH,
Bernie
MS Excel MVP