Tuesday, February 10, 2015

In Excel 2013, where are Visual Basic (VBA), Macros and AddIn tools?


In Excel 2013, where are options and tools such as Visual Basic (VBA), Macros and AddIn tools? Are they supported?


Answer



By default, Excel 2013 doesn't show developer tools.


They can be enabled by selecting File → Options → Customize Ribbon.


In the Customize the Ribbon (Main Tabs) window pane, scroll down to the Developer option and check it. Now Excel will display a ribbon tab named Developer.


No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...