This blog post will show you how to create an Excel Macro using VBA to protect multiple Excel worksheets in an Excel workbook. Have you got multiple sheets you need to protect in an Excel workbook?. It can be quite time-consuming to individually protect them. I have a number of workbooks that I regularly have to protect and unprotect on a regular basis to update and then share them with a number of users. Some of those Excel workbooks have a lot of individuals worksheets. To illustrate, you … [Read more...]