VBA Unprotect sheet with password

preview_player
Показать описание
Remove the protection from the sheet with the password needed. Un-protecting a worksheet will make it available for edit.

Code:
Sub remove_protection_sheet()

'remove password from protected sheet

Dim ws_sheet As Worksheet
Dim myPassword As String

'identify sheet
Set ws_sheet = Worksheets(1)

'set password
myPassword = "KevinBrundu"

'remove protection
ws_sheet.Unprotect (myPassword)

End Sub

-------------------------------
NEED HELP?
-------------------------------
Leave a comment with your questions, issues or projetcs and I will try to answer with a video.

-------------------------------
THANK YOU
-------------------------------
For watching my videos,
Your shares
And your comments!
Рекомендации по теме