Data Security

How to protect your VBA code in Excel 2010

00065_ProtectVBA_FI

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

00034_excel-protect-cells_fi

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