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!