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 vote171 views1 answer
Internet explorer reference vba
VBA
0 vote188 views1 answer
Group controls programmatically vb
VBA
0 vote173 views1 answer
Vba pass named range to function
VBA
0 vote170 views1 answer
Vba string
VBA
0 vote174 views1 answer
Excel vba calculate
VBA
0 vote170 views1 answer
Excel vba delete folder
VBA
0 vote163 views1 answer
Afficher un message d'erreur vba
VBA
0 vote166 views1 answer
Vb check if row has column
VBA
-1 vote163 views2 answers
How close excel through visual basic
VBA
1 vote167 views1 answer
Excel vba compare 2 rows
VBA