Data Security

How to make your Excel Workbook Read-Only

There are times when you need to protect your Excel Workbook from unauthorised changes made by other users.  You can deploy the Read-Only option to your Excel Workbook to prevent unauthorised users from making changes, find out how below… Protecting…
Read more

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