Friday, January 11, 2013

VBA coding and template designing for 2013?

How to enable excel 2013 developer tab for VBA coding and template designing.


1. First ope the `backstage view' of excel 2013 by clicking the "file" option in the ribbon.
2. Click Options -> a Pop Up apprears.
3. Cick "Customize ribbon" Option.
4. In the right column choose the "Main Tabs" from the dropdown (by default it will be there).
5. please check the ‘Developer’ cehck box.
6. click OK -> close and reopen your excel.
you have successfully enabled the Developer tab and have access to all kind of developer tools in excel 2013 to begin your development.

No comments: