Tag Archives: excel password

Automatically Protect/UnProtect All Worksheets

Tonight I want to automatically protect and unprotect all Microsoft Excel Worksheets in my Workbook with password, instead of doing it manually, I put these following Excel VBA macro code in my Workbook. Public Sub ProtectAllSheets() Dim objSheet As Worksheet … Continue reading

Posted in Workbook and Worksheet | Tagged , , , , , , , | 4 Comments