Excel vba password protect

' Password for opening
ThisWorkbook.SaveAs Password:="my_password"
' Access granted, password required for modification
ThisWorkbook.SaveAs writeResPassword:="my_password2"

Excel vba protect worksheet without password

Worksheets("Sheet1").Unprotect "Password"

Source: automateexcel.com

Similar codes

0 vote342 views1 answer
Vba pass named range to function
VBA
2 votes350 views1 answer
Excel vba date to string conversion
VBA
0 vote393 views1 answer
Sort dictionary by key vba
VBA
0 vote388 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote358 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote378 views1 answer
Vbnet find highest value in chart
VBA
0 vote371 views2 answers
Checking and changing system volume vb.net
VBA
0 vote356 views1 answer
Visual stuiod not recognising desgined labels
VBA
1 vote381 views1 answer
How to remove zeros in excel
VBA
1 vote368 views1 answer
Excel vba force recalculation
VBA