Will a Macro created in excel 2007 work in the 2010 environment?

Will a Macro created in excel 2007 work in the 2010 environment? I am creating a macro to collate data, vlookup from a mastersheet to fill the gaps in data, and format the data to a particular set format. I am using Excel 2007 and just learned that the person who will use this macro is working in the 2010 environment. I need to know if I will continue working in 2007 or should I work in the 2010 environment already. Thanks!

Ya ofcourse it will work ..!

I was using excel 2007 until one, or two months ago and had lots of macro in 2007. I have now 2010 and do not see any problem. The only issue you need to be aware is the macro settings.

Thanks, Rasheed_Pro! I just got scared when I read in some net sites that 2007 Macros may have problems being executed in 2010. Hope that won't be the case with what I am trying to do.

Hi, AB33, What do you mean by Macro Settings? Are these the 4 settings with disable and enable macro settings? Thanks!

Are these the 4 settings with disable and enable macro settings? Thanks! Yes

Many thanks! Wish me luck as I create my first full macro (besides the ones that make words pop out for error entries).

What AB33 is mention also correct... There is excel option macro some advance features added in 2010

Best of Luck