Excel 2007 Macro

M

MacroIssue

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top