Data Security

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

Protect Cells and Formulas in Excel

There are times when protecting certain cells, formulas, or entire worksheets in Excel is a useful practice to adopt.  Read on to find out how to prevent your Excel worksheet from unplanned changes… Protect Cells and Formulas in Excel When…
Read more