In Excel 2007, you have to designate a directory as "trusted" or else it automatically disallows any macros in a workbook residing in an "untrusted" location. That might be part of your problem.

To flag a directory as "trusted", click the "Microsoft Office Button" in Excel, then select Excel Options (a command button at the bottom of the 'menu', next to Exit Excel). In the left-hand pane of the window that appears, click Trust Center, then in the right hand pane click the Trust Center Settings button. Back in the left-hand pane, click Trusted Locations, then in the right-hand pane click the Add New Location button. (If the location is on a netowrk, you'll need to check the "Allow Trusted Locations on my network" box, first.) Enter the directory path, then click the OK buttons until the new window is removed.

Now take a deep breath and remember how easier it was with Excel 2003.

By the way, there are at least two ways to record a macro. One is through the Developer option in the ribbon, using the Record Macro 'button' in the Code section. The other is through the View option in the ribbon, clicking on the Macros 'button' in the Macros section and choosing Record Macro.

Hope this helps.