Before doing or editing a project in Macro you should activate macro and explore the developer tab first.
1. Select the “Microsoft Office” button and click “Excel option”
2. Select the option “Advanced” and choose “Show developer tab” option.
3. Select “Trust Centre”, click “Trust Centre Settings” and choose Macro Settings.
4. Select “Enable all macros” and click “Trust Access to VBA project object model” option.
5. Select OK button.
Run Macro: go to the developer tab and select Macro. Run macro by clicking the “Run” button. Edit macro: select “Step into” button, the desired VBA code will be opened for editing the selected macro.
Points of Interest
Some of the basic features used in this project are: Macro, VBA, Module, Workbook, Sheet, Cell, Developer Tab, Insert Controls, Microsoft Excel 2007.
History
24/04/2012 - Article Created
Please download the source code from the below link and try experimenting with the source code.
Car Showroom Servicing Billing Source