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 vote214 views1 answer
Excel vba select multiple shapes
VBA
5 votes214 views1 answer
Excel vba high word from Long Integer
VBA
0 vote227 views1 answer
Arq linux
VBA
0 vote223 views1 answer
Excel vba cell on change
VBA
0 vote173 views1 answer
Excel vba arrondir
VBA
8 votes531 views1 answer
Excel vba make word from bytes
VBA
18 votes395 views3 answers
Excel-vba make integer
VBA
0 vote216 views1 answer
Vba static variable
VBA
0 vote237 views1 answer
Find if year is leap year vb
VBA
0 vote210 views1 answer
Vba add shape oval
VBA