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 vote181 views1 answer
Discern between file and folder given path vb.net
VBA
1 vote163 views1 answer
Excel format cell as kilowatts
VBA
0 vote191 views1 answer
.net crash app
VBA
0 vote186 views1 answer
Vba array of integers
VBA
0 vote179 views1 answer
Nested if else in vb.net
VBA
0 vote183 views1 answer
Remove first character from string vb
VBA
0 vote186 views1 answer
Date as number vb
VBA
0 vote167 views1 answer
Vba check 32 or 64 bit
VBA
0 vote159 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote181 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA