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 vote272 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote286 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote290 views1 answer
Dynamic array vba
VBA
0 vote293 views1 answer
Vb run command
VBA
0 vote298 views1 answer
.net crash app
VBA
0 vote268 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote285 views1 answer
Vbs write file
VBA
0 vote316 views1 answer
Vba extract filename from path
VBA
0 vote248 views1 answer
How to sort datagridview in vb.net
VBA
0 vote316 views1 answer
Method showalldata of object _worksheet failed vba
VBA