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 vote233 views1 answer
Excel vba cell on change
VBA
0 vote317 views1 answer
Vba change active sheet
VBA
-1 vote255 views1 answer
Code for reading letters only in vb 6
VBA
0 vote233 views1 answer
Regex numeric digits
VBA
0 vote235 views1 answer
Excel vba unmerge sheet
VBA
0 vote221 views1 answer
Vba file size
VBA
0 vote275 views1 answer
How to call gcd in vba
VBA
0 vote228 views2 answers
Do until loop vba
VBA
31 votes284 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote228 views1 answer
Make all controls in an area not visable vb
VBA