Mikey Bronowski shows us a few techniques for protecting data in Excel files using Powershell:
Last month we have been hiding things in Excel, so this week we are going to make sure they are protected as well. Excel offers multiple levels of password protection and its options:
– locking file with a password, i.e. without key phrase opening file is not possible
– protecting workbook’s structure
– lastly, protecting individual worksheets from a handful of operations
Read on to see each of those in action.