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 vote351 views1 answer
VBA is form loaded
VBA
25 votes471 views2 answers
Excel vba folder exist
VBA
15 votes478 views1 answer
Excel vba wait
VBA
1 vote349 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote334 views1 answer
Vbs send keys
VBA
4 votes334 views2 answers
Vba create folder if not exist
VBA
1 vote325 views1 answer
Excel vba first and last row and column in range
VBA
0 vote342 views1 answer
Vba get relative cell address
VBA
1 vote342 views1 answer
Excel vba force recalculation
VBA
0 vote360 views1 answer
Vbnet cycle through charaters in string
VBA