Forum Discussion

trevor1959's avatar
trevor1959
Copper Contributor
Mar 18, 2021

VBA code to unprotect

Hi 

 

I have a VBA code that converts formulas to values (see below) however the sheet is protected therefor I need to add to my code that will unprotect the sheet and then protect the sheet when completed. Note there is no password on the protection.

 

Sub ConvertToValuesByRangeDetailedReport()
CarryOn = MsgBox("Do you want to lock this report? Once locked the report can not be unlocked.", vbYesNo, "WARNING")
If CarryOn = vbYes Then

With Range("A1:L205")
.Cells.Copy
.Cells.PasteSpecial xlPasteValues
.Cells(1).Select
End With
Application.CutCopyMode = False
End If
End Sub

No RepliesBe the first to reply