Sat 05 Aug 2017

VBA - Data Masking or Anonymize the Data through a Macro

By |Saturday, August 05th, 2017|Categories: VBA|Tags: , , , , , , , , , , , , , , |0 Comments

Sometimes, you may need to sanitize your data before sharing your file. The below macro would sanitize the data and since this is completely based on random generation, hence, it can not be recreated.

Make sure that you have a copy of the Excel sheet before you sanitize or mask or anonymize the data by running this data. As once done, the data can not be recreated.

The Excel file related to this article can be downloaded from Data Masking Macro

(more…)

Sat 14 Feb 2015

Article 11 - How to Encrypt Excel Workbook

By |Saturday, February 14th, 2015|Categories: Articles|Tags: , , , , , , , , |0 Comments

Note - The article is for Excel 2010 / 2013 versions and doesn't cover any version prior to Excel 2010.

Excel 2010 / 2013 uses default 128 bit AES encryption which is considered highly secured. If you are interested in knowing all things about Excel security, I will recommend following MS article -

http://technet.microsoft.com/en-us/library/dn194021%28v=office.15%29.aspx

---- Update on 27-Jun-15 - Following is a very good article which contains some useful info on Excel security -

http://www.thespreadsheetguru.com/blog/2014/8/20/understanding-excels-password-security-methodology ----

Anyway, coming back to topic, there are 4 ways to encrypt Excel Workbook (Not counting VBA to do this which is not a safe way to encrypt).

1. Way 1 - Encrypt Document Button - This is recommended if you encrypt your workbook very often. (more…)