Video : how to add the Developer Tab in Excel 2007
Before starting writing Macro in Excel 2007/2010, we need a Developer Tab, where all the controls, options, and settings are there for Excel VBA. You can add the developer Tab in your excel 2007 or 2010 easily by going through the below-mentioned steps.
Step by step guide to add Developer tab in Excel-2010
- Click on File of the Excel Workbook
- Click on Option
- Go to “Customized Ribbon”
- In Right hand side in “Main Menu” Option check the “Developer” check box
- Click OK
Step by step guide to add Developer tab in Excel-2007
- Click the Office Button
- Click the Excel Option button at the bottom
- Go to the Popular button at the left
- Under Top Option for Working with Excel, check the Show Developer tab in the Ribbon option.
- Click OK button to finish editing.
Hi,
Could u tell me how to name our macro once we click on the macros icon on top of d corner