Remove protection from multiple sheets (here 150)
Solved
Hello,
is it possible to remove the protection from 150 sheets at once???? I already have some removed but not all.... thank you for your help
Configuration: Windows / Chrome 53.0.2785.116
is it possible to remove the protection from 150 sheets at once???? I already have some removed but not all.... thank you for your help
Configuration: Windows / Chrome 53.0.2785.116
2 answers
-
Hello Noila,
Paste the following code into a module of your file and run the macro from "Macro" in the "Developer" tab, it will remove the protection from each sheet of your workbook.
Sub deproteger() Dim ws As Worksheet For i = 1 To Worksheets.Count Set ws = Worksheets(i) ws.Unprotect Next i End Sub
Have a great day
Jc
