How to protect your VBA code in Excel 2010

VBA scripts are usually written by Excel experts or enthusiasts in order to achieve everything from simple automations through to highly detailed processing and report/dashboard creation.  When you write a VBA script for an Excel file you should consider protecting…
Read more

How to close Excel using VBA

The need to close Excel after running a macro arises all the time especially in large-scale Excel reporting automations where you may be collating data from multiple Excel files.  To learn how to close Excel from within VBA then read…
Read more

An overview of Charts in Excel

Charts are one of the most powerful visual features of spreadsheet software like Microsoft Excel 2010, if you have never used Excel 2010 to create a chart then you are missing out on a key feature of Excel.  Get to…
Read more