In Excel 2010, after you record a macro, you need to run it to make it work. The Run button is in the Macro dialog box ...
office.microsoft.com