Enable Developer Tab
To work with the Macro Recorder or VBA (Visual Basic For Applications) you need to enable the Developer Tab first.
This is how you do it -
For 2007 Version -
Click on the Office button on the Left top corner
Select Excel Options
On the Popular Tab, check the box in front of “Show Developer tab in the ribbon”
For 2010/2013 Version -
Click on the File Tab
Select Customize Ribbon
Check the box in front of “Developer”
Interested in learning how to use the Macro Recorder?
Check out my course - Power Of Macros in 60 Minutes