VBA code to protect/unprotect all sheets at once
How to protect all worksheet using VBA Macros. Please do as follows: 1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window. 2. Click Insert > Module, and paste the following code in the Module Window. Sub protect_all_sheets() Dim pass As String Dim repass As String Dim i As Integer Dim s As Worksheet top: pass […]